Dear Friends,
PFA the file.
I need to calculate amount in col K.
is there any formula which can calculate the amount since the data is huge and calculating the amount manually is time consuming.
Please assist.
Dear Friends,
PFA the file.
I need to calculate amount in col K.
is there any formula which can calculate the amount since the data is huge and calculating the amount manually is time consuming.
Please assist.
On the proviso the sample data is truly representative of the real data, i.e. the SOL ID column really does contain 1 Total, 2 Total etc. then the below formula in K9 and copied down could work.
Formula:Please Login or Register to view this content.
BSB
Wow....
You made my day,,,,
Thanks a ton.
Happy to help
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks