IF FALSE, SKIP TO NEXT TRUE ROW - Need formula, not filters

[rwernlund]

Hello, I'm trying to figure out how to use the IF function or any function for that matter to grab info from a row if its true, but then if the next one is false, instead of giving me a blank line, it would skip to the next TRUE row. I do not want this to be done by creating filters. I need a formula for this.


See attached


Also, I do not know very intricate formulas so when you post one please tell me exactly what the formula is telling me to do please

Something like: "The formula is telling excel to do this while doing that because of this part of the formula...and then it's saying to do this because of this part..."

Thank you! please help!

[JohnTopley]

See attached ....

[berlan]

Can't get the date for credit to work, but as an example try this in the following cells:

S7: =IFERROR(INDEX($B$3:$F$20,AGGREGATE(15,6,(ROW($B$3:$F$20)-ROW($B$2))/(LOWER($C$3:$C$20)="cash"),ROWS($B$3:B3)),COLUMNS($B$3:B3)),"")

T8: =IFERROR(INDEX($B$3:$F$20,AGGREGATE(15,6,(ROW($B$3:$F$20)-ROW($B$2))/(LOWER($C$3:$C$20)="cash"),ROWS($B$3:E3)),COLUMNS($B$3:E3)),"")

U8: =IFERROR(INDEX($B$3:$F$20,AGGREGATE(15,6,(ROW($B$3:$F$20)-ROW($B$2))/(LOWER($D$3:$D$20)="cash"),ROWS($B$3:F3)),COLUMNS($B$3:F3)),"")

any copy down.

Hope this helps.

//berlan

[Ron Coderre]

I can't post workbooks from my job...
But

Using your posted workbook.
Debit Date formula

Please Login or Register  to view this content.

Debit Amount formula

Please Login or Register  to view this content.

Credit Amount formula

Please Login or Register  to view this content.

Credit Date formula

Please Login or Register  to view this content.

Adjust range references to match your situation.
Copy those formulas down as far as you need.

Those formulas allow for other accounts to have posting activity mixed in with the Cash and Inventory.

Is that something you can work with?

[rwernlund]

thank you guys! I will try this as soon as I get a chance. Won't mark as solved yet