Forum Discussion
SUMIF for first values only
Hello SergeiBaklan .. the above pic is the result from the formula suggested by Wyn Hopkins ..(which does not quite work out)
I need column E to show only the first value of the budget for that GL (for that month) .. i.e GL 57010107 on row 12 should show 8,333 in column E .... E14 and E15 should show zero as the GL is a duplicate for Jan .. similarly costs relating to Feb should show 8,333 in E76 and zero values for E77 and E78 ..
Hope this clarifies
Thanks for your time
SergeiBaklan what happens if I have the same amount on multiple rows lets say once for jan and once for feb, is this formula gonna return 0 for the one in february that I still need? how do I transpose this formula to work for text? i only need it to detele the duplicate lines next to each other, but if that same value appears a few rows below, I need it there
Not sure I understood what you need. Could you please share small sample to illustrate the task?
Hi,
What I need is a formula in column D that will show date resolved minus date received for each individual code. The date resolved will be selected for each code based on status solved, minus the date received for the same code but on status received. I already did this by doing a sumifs minus sumifs, but when I have multiple lines for the same status it gives an error bc sumifs cannot recognize which date to pick from.
arumel , you are welcome, glad to help
