Bora wrote to me last week and asked for my Excellent help. I responded by saying, ok, I can do this on Monday. She replied to say, Wow! I didn't expect you to reply!!
It was an interesting problem: a database with over 41000 rows needs to be interrogated using four variables. I offered two separate solutions: use and sort on an Excel Table and use SUMIFS()
Both solutions worked a treat and Bora was delighted I am happy to say.
Good stuff!
Duncan Williamson
No comments:
Post a Comment