Thread: If And Help?
View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] vidguru@gmail.com is offline
external usenet poster
 
Posts: 18
Default If And Help?

The only other thing I can think about doing is creating a column and
do =G2&" "&L2&" "&M2 and fill it down. Sort by this new column, then
by paid amount and then do my =IF(AND(G2=G3,S2=S3),"D","") and filled
it all the way down. Either way, I think mine is just adding a bunch
of extra steps and wasting computing power when I am sure there is a
better way :) I keep adding my thoughts so you guys don't think I am
just twiddling my thumbs and not trying to figure this out :)