Forum Discussion
Solved
Help with forumla
I have been struggling to work out the correct formula in the attached spreadsheet. What I am trying to do is to work out how many Job’s each solar provider has done per state. I have tried V & X loo...
I got this from your question.
You want to find out which partner has done how many projects in certain states. If this is the case, just go for the pivot table .
YES IT LL HWLP YOU AND
CLEAN YOUR DATA PLEASE.
https://gyankosh.net/msexcel/how-to-use-pivot-tables-in-excel/#gsc.tab=0