Not really a question . . . . . . . . . .

[MarkAndrews]

There’s probably a more efficient way of doing what it does but it has just grown gradually over the last week or so as I kept adding bits to verify different stuff!!!

As daft as this is going to sound, I like nothing more than looking at other peoples formula's, breaking them down etc - I find it increases my knowledge sometimes and opens up other avenues to explore with formulae

 

[Lewiy]

As daft as this is going to sound, I like nothing more than looking at other peoples formula's, breaking them down etc - I find it increases my knowledge sometimes and opens up other avenues to explore with formulae

I completely agree…although sometimes it helps to know what the source data looks like…otherwise it can leave you more baffled and confused than when you started!!!

 

[Harley78]

My goodness,,, how does one figure these out dangggggggggg

 

[MarkAndrews]

I completely agree…although sometimes it helps to know what the source data looks like…otherwise it can leave you more baffled and confused than when you started!!!

Couldn't agree more Lewiy, although sometimes you can guess what some of it looks like from the formula (Time, Eomonth etc), or the ranges used

 

[Domski]

As daft as this is going to sound, I like nothing more than looking at other peoples formula's, breaking them down etc - I find it increases my knowledge sometimes and opens up other avenues to explore with formulae

It takes me long enough to figure out some of my own formula, especially after a particularly heavy weekender

 

[gingerafro]

And I'm just now seeing this little gem?! This is one that I'll be trying out!!! Thanks, Jon (and Smitty)!

And I'm only just seeing it now....!! That'll save so much space with my extensive overuse of isna and getpivotdata. Wow.

 

[MarkAndrews]

It takes me long enough to figure out some of my own formula, especially after a particularly heavy weekender

You need to book some more AA meetings mate.....

**me too **

 

[Domski]

I'm giving up the cigs next week. One step at a time

 

[MarkAndrews]

I'm giving up the cigs next week. One step at a time

I was in <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1lace w:st="on">Leeds</st1lace> the other week mate, Revolution (Top), Courtyard, Sports Bar, Squares, Yates (Bottom) & Flares!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Had a brilliant night, last train home mind, back to ‘wonderful’ <st1lace w:st="on">North Yorkshire</st1lace><o></o>
<o> </o>
5pm – 5am drinking & No Hangover!! RESULT!<o></o>

 

[schielrn]

=IF(ISBLANK(C2),ROUND(INDEX(Reserve!A:A,MATCH(A2,Reserve!W:W,0)+1,1),0),-ROUND(SUMPRODUCT(--(INDIRECT("Reserve!$"&SUBSTITUTE(ADDRESS(1,MATCH(C2,Reserve!$3:$3,0),4),1,"")&"$29:$"&SUBSTITUTE(ADDRESS(1,MATCH(C2,Reserve!$3:$3,0),4),1,"")&"$1458")),--(Reserve!$A$29:$A$1458=B2),--(Reserve!$W$29:$W$1458=A2))*LOOKUP(RIGHT(C2,1),{"2","3","4","5"},{0.25,0.5,0.75,1}),0))

This is what I use to book our reserve for inventory because the report that I receive from the field is not in a user-freindly fashion. Which reminds me that I need to speak with them to get this in a better format.