I am using Excel 2007 and am trying to introduce a column into the .csv log showing the total points from each activator.
I have tried using the Logical fomula using ‘IF’ but this seems longwinded and would require an entry for each callsign. I require an automatic formula for say column ‘J’ which gives a running total as the call is entered. Suspect I may require to use the ‘Conditional Formula’ but when they start talking about ‘Pivot Tables’ etc, my brain seems to switch off!!
Any database expert here with a possible solution please?