Hello
I'm an intermediate user and can usually google my way to a solution but this one has me stumped.
I want to pull data into a spreadsheet that will be imported directly into software. Rows with $0 will create an error with the import. So what I'm looking to do is return values from an array only if the $ cell is >0. If it's not >0, I want it to move to the next row and so on until it finds a row with a $ value >0.
For example, this table -
table.PNG
Would be consolidated to this -
import.PNG
The code, hours, and value are returned, but only for rows where the value >0, and there are no blank rows in the import.
Thank you for your time!
ETA: Using MS Office professional plus 2019
Bookmarks