$$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach Sheet..

2015-11-01 Thread big smile
Respected Guru's .. I want to learn the formula so that I get the folllowing results 1] In the sheet 1 - I am choossing option A & B I am chossing any two comparision 2] Ex If I choose Star Comprensive The New India - FLOTER 3] I want the result as follows Then auotmatically My sheet 2 wi

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-01 Thread Will Sob
l meant from C8 to H78 I need a formula to look up when balls from 1-59 was last drawn and then look at the date this draw occurred and then calculate the difference between that date and today's date I dont know if this is possible it should look like this below 0 26 0 39 0 41 0 42 0 55 0 56 0

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-01 Thread ashish koul
check this see if it helps On Sun, Nov 1, 2015 at 6:26 PM, Will Sob wrote: > I need the formula to look up when for example ball 33 was last drawn and > then look at the date this draw occured and then calculate the difference > between that date and todays date > I dont know if this is possible

$$Excel-Macros$$ I need the formula to look up

2015-11-01 Thread Will Sob
I need the formula to look up when for example ball 33 was last drawn and then look at the date this draw occured and then calculate the difference between that date and todays date I dont know if this is possible -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TI