Hi Luke,
This formula is awesome..but request you to help me out in understanding the concept of the above formula..
I mean am unable to understand the concept of using {ROW(INDIRECT("1:"&LEN(B3))),} in the above formula....
Regards,
Abhinav
Hi,
Am compiling some report received from different vendors wherein am facing little issue while adding some digits..as the vendor are sending some data in one cells for a individual person e.g.
A B c
Ram 24
Vicky 579
where i want the added total of B in C like 24 = 6, 579 = 21 as on...
Hi Luke M,
Thank you,
The above formula is working perfectly...but as this is the mega formula am little confused to understand it. And am afraid if i have to make certain changes while using this formula whether it will work or not.
Request you if u can illustrate the above both formulas...
Hi All,
Its been a very long time I had encounterd with a new problem. I used to get raw data from our different vendors who used to entry datas in Excel. Datas like Customer Name, Phone numbers, Address and many other stuffs as well.
The problem what I am facing is they ( Vendor) used to...
Hi,
My work is to make reports analysis..many more things...while I was working on a very little thing I encountered with the problem that for the dates before 1900 we need to use VBA codes..
Is there any options or alternatives to work on such things without using VBA codes..
Regards...