HeyItsDizzy
New Member
- Joined
- Apr 11, 2018
- Messages
- 20
I am wondering how can i find the latest information that meets my criteria, because all my table are run form a formula we the "Blank" cells will always read as a')', there fore i am having a Countif, Sumif, Maxif, etc issues, i am probably just typing my formula incorrectly.
Based on the following table, I need the Red X to equal '5'. Lets say for example i have already collated my data and all I am looking at is Salesmen 'John', lets also preten that John made not sales in Month 3 because he was on vacation, but all i want to know when that last sale was made in this case the '5th' month was his latest sale. as stated all cells will have numbers in them as that infor is fed through other formulas, as you know if a formula returns 'Nil' as a result then a '0' is placed in the sell
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Name[/TD]
[TD="align: center"]John[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Lates sale made[/TD]
[TD="align: center"]'x'[/TD]
[TD]'th Month[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Month[/TD]
[TD]Sales Made[/TD]
[TD]Sales ($)
[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Based on the following table, I need the Red X to equal '5'. Lets say for example i have already collated my data and all I am looking at is Salesmen 'John', lets also preten that John made not sales in Month 3 because he was on vacation, but all i want to know when that last sale was made in this case the '5th' month was his latest sale. as stated all cells will have numbers in them as that infor is fed through other formulas, as you know if a formula returns 'Nil' as a result then a '0' is placed in the sell
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Name[/TD]
[TD="align: center"]John[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Lates sale made[/TD]
[TD="align: center"]'x'[/TD]
[TD]'th Month[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Month[/TD]
[TD]Sales Made[/TD]
[TD]Sales ($)
[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]