Hi All,
I am facing an issue while creating ageing report. I have a data having duplicate name, slab wise data and count. What i want is when i put the name and slab amount i should get a count on the basis of slab. Hope you get what i want to say. Please refer the excel attachment
Regards,
Hari
It's not clear how you want the result calculated.
You've picked Harindra and 72708. I can understand the name but what does 72708 represent?
Can you give expected answer and how you figured it so we can suggest formula?
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Thanks for the message. If you see Slab1 and Slab2 column, 72708 is not between any slab till 4 row in Harindra case, once i come to 5 row the condition is 72708 is greater than 35000 then in count column it should show 80. Same way for other
Try:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks