How do I create an equation to determine the salary increase here

[ezzat]

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total Increase
2300	2875	2875	2875	2875	3625	3625	3625	3625	3625	3625	3625
			1000	2500	3250	3250	3250	3250	3250	3250	3250
	1500	2875	2875	3625	3625	3625	3625	3625	3625	6500
				2875	2875	2875	3625	3625	3625
		2500	3250	3250	3250	6000
1000							2500	3250	3250	3250	5000

 

[Joe4]

Assuming that you want to subtract the first entry in each row from the last entry in each row, try this formula (assuming first range is A2:L2):

=LOOKUP(2,1/(A2:L2<>""),A2:L2)-INDEX(A2:L2,MATCH(TRUE,A2:L2>0,0))

Proof:

 

[ezzat]

=LOOKUP(2,1/(A2:L2<>""),A2:L2)-INDEX(A2:L2,MATCH(TRUE,A2:L2>0,0))

Thanks , put not aworking

 

[Joe4]

Thanks , put not aworking

I am not sure what that means. Are you saying it is not working?
As I demonstrated, it is working for me.

Can you show us the results you are getting?
Are you blank cells really blank, or are there formulas or spaces in them?

 

[ezzat]

100

100

100

500

500

500

500

500

1500

1500

1500

1500

#VALUE!

 

[Joe4]

It works just fine for me, which leads me to believe that either you are not applying the formula correctly or there is something else you are not telling us.

Can you do the following things?

1. Confirm the version of Excel you are using using commas (,) and not semi-colons as the separators for arguments in your formulas.
2. Show us a screen print that show your column and row headers so we can see exactly what rows and columns your data is in.
3. Show us the exact formula you are using that is returning this #VALUE error.

 

[ezzat]

 

[Joe4]

Can you try breaking up the formula into two pieces?
Enter them in any two blank cells, and see if either one returns a value or an error?

=LOOKUP(2,1/(D5:O5<>""),D5:O5)

and

=INDEX(D5:O5,MATCH(TRUE,D5:O5>0,0))

Also, can you please confirm that your version of Excel uses commas or semi-colons between arguments when entering formulas?

 

[Arts]

Great way of attaining the first entry INDEX(A2:L2,MATCH(TRUE,A2:L2>0,0)), I was thinking of using MIN when I first saw this but thought that maybe the wrong way to approach it.