7 Replies Latest reply on Sep 19, 2018 3:41 AM by Jim Dehner

# Find First value through the row and use it

Hello folks,

I have been trying with FIRST() function to resolve my problem but obviously it works only for the first Week (first column) that I take in consideration.

So, my goal here is to find first 1 in every single row and take it as value. All the rest values at that row, after this 1, should have 0 as value.

As I said, my FIRST() calculation doesn't work so I guess I need another approach to this. Picture below - FIRST() works fine for the first column, but for the second, third, etc. column (week 2) it doesn't work.

And just once again - Need to go through the RAW on a weekly basis!

I hope that you understand me

Attached is the workbook.

• ###### 1. Re: Find First value through the row and use it

Good morning

see the attached

try this

it returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Find First value through the row and use it

Nice work Jim.

Thank you!

• ###### 3. Re: Find First value through the row and use it

Thanks

enjoy the weekend

Jim

• ###### 4. Re: Find First value through the row and use it

Hello again,

I need to revive this topic once again in order to see how to resolve additional problem

So, I you could see Jim created a solution how to find first value (based on a "Reference") and use it in the table.

Now, I need to build a bar chart from this table but to Remove "Reference" from Rows shelf. If I do that I lose my calculation and it doesn't work.

Any kind of assistance would be grateful.

Thanks!

• ###### 5. Re: Find First value through the row and use it

see the attached

it returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 6. Re: Find First value through the row and use it

Wooow!! Exactly what I needed!

Thank you very much once again!

Cheers!