Hi Guys!
i have enough data to work on. I have collected data in sheet 2 E (green highlighted) column now i want to show data in sheet 2 D (yellow highlighted) as per given percentages in Main sheet. need your help to solve this.
Hi Guys!
i have enough data to work on. I have collected data in sheet 2 E (green highlighted) column now i want to show data in sheet 2 D (yellow highlighted) as per given percentages in Main sheet. need your help to solve this.
with index / match
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
its working on attached sheet but in my sheet some services specially Family Planning Counseling services showing 0.
what 0 => 0% or 0 value?
without seeing that data it is very difficult to tell the reason for the problem.
it is showing 0 value
Check spellings on headings or leading/trailing blanks.
I found it. i am selecting centers from they start not from first blank row. Thank you so much dear.
You're welcome. We appreciate the feedback!
Thanks for marking your question solved.
It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks