Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange Formula Request
Hi. I have no idea how to construct this formula. It could be in vb, but
doesn't have to be. Below is a database dump from a timesheet program. What I need to do is populate the % of Total column as shown below. For users in states OTHER than CA, we can ignore. For CA entries, the program creates a total line for me. The data is always sorted by user, then by state. So CA data is always lumped together per user with the ca_total directly below the last CA entry. How can I formuate excel to know that jblow has 2 CA entries totaling 98, and the % of the total for each line is 64% and 36%?? Any help would be greatly appreciated! Thank you!!! user State Total % of Total jblow AL 28 jblow CA 63 64% jblow CA 35 36% jblow ca_total 98 bdole AK 18 bdole CA 38 53% bdole CA 34 47% bdole ca_total 72 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Request | Excel Worksheet Functions | |||
Strange request: Counting cells and percentages | Excel Discussion (Misc queries) | |||
Formula request | Excel Discussion (Misc queries) | |||
Formula help request | Excel Discussion (Misc queries) | |||
formula request | Excel Worksheet Functions |