Dear All,
PFA the file for your ref.
I need to calculate % in col H.
Doing it manually is very time consuming since data is huge.
Please assist.
Dear All,
PFA the file for your ref.
I need to calculate % in col H.
Doing it manually is very time consuming since data is huge.
Please assist.
Last edited by AliGW; 08-05-2018 at 10:52 AM. Reason: Moved to appropriate forum section.
Hi,
Put this in H9 and pull it down.
=+G9/SUMIF($D$9:$D$21,D9,$G$9:$G$21)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Marvin,
Sorry to tell u that formula does not work.
It does not give the desired result as mentioned in col. H.
Please assist.
In "H9"Formula:Please Login or Register to view this content.
In "H17"Formula:Please Login or Register to view this content.
Copy paste according data record.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Sorry brother.
Currently I have put this formula only.
In my data, there are approx 25000 rows.
So this formula of yours would be time consuming and too manual.
Is there any other formula which can reduce my manual work?
Please assist ..
Thanks dear, in this case can you share / attach your file with desired required result.
Try this. I am not so sure it will perform well over 25,000 rows.
Please let us know.Formula:Please Login or Register to view this content.
Note: I tried without success to get this to work.It didn't and I am mystified why. According to my online source MATCH in Excel 2003 should accept wildcards. It didn't in your upload.Formula:Please Login or Register to view this content.
Update: This works. I suspect it will perform best of all.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 08-05-2018 at 08:46 PM. Reason: simplified formulas
Dave
If your data record more than 25000. I suggest you to change little bit data structure.
Refer attach file.
In this file i have created summary sheet with unique "Sol ID" & Sol Desc" & sum of total with sumifs formula.
In Data sheet "F2" formula is :copy paste down.Formula:Please Login or Register to view this content.
In this case you avoid manually work & time saving.
hope this will helpful you & your problem resolved.
Thanks a tonne....
You guys made my days.
You are welcome. Thank you for the feedback and marking this Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks