Search results

Thx Hui also - both worked brilliantly.

Superb Pavan, thankyou ever so much for doing this. Appreciate your time in looking, sorry if my thread description wasnt clear about what the problem was before you looked at it.

Hi, I have a list of dates/values and what i want to do is look at these dates (Sunday-Thusday). If the date falls on a friday/sat/sun then ignore and move onto the next date(as these days dont have a value). Basically i am comparing week on week, but because a week has a friday etc within it...

I have attached the spreadsheet update as the formula doesnt work on multiple rows - see what you think - The spreadsheet shows how the data is laid out - so the forumula needs to check all dates in all coloums, find the stated date and then give me 1 cell below it. Thanks again

Narayan you are the man - thankyou so much for this.

well dont understand macros - thanks anyhow

Basically - its one sheet laid out like attached document, with numerous dates going back from1st January, and under each date is a set of numbers. I need a forumla that searches the whole sheet for the date required, then give me the value underneath.

Hi all, I am trying to put a lookup together that has numerous dates on a sheet and under these dates has the relevant data. This is a rolling document, so as we go on in the year, the dates get lower in the rows. So what i am requiring is a forumla, that would look for say the date 24th...

Great stuff thanks both, all working nicely now.

Morning everyone - I have this formula =VLOOKUP($S$739,A:L,10,FALSE)&" passes have taken place on the football.com website and is "&TEXT(ABS($AF$737)," #%")&" lower than the previous week" The issue is $AF$737 can be a negative or positive % i.e -10% or 10%, so what i need to happen is the...

Perfect thx Bhawani :)

Hi all, Got this formula =IF(INDEX([source]Feeder!$E$2:$E$5003,ROWS($A$1:A49))=0,"",INDEX([source]Feeder!$E$2:$E$5003,ROWS($A$1:A49))) Basically it is looking at a table of data that is returning N/A - how do i adapt this formula to ignore N/A and return a blank cell, until a value is...

Thanks for the replies and sorry i was late getting back to you all. That is perfect

Hi, I am trying to add two dropdowns to the attached spreadsheet, so when i select any TWO dates , another box will automatically sum the column to the right with the figures between the two dates... I know this must be some sort of offset function, but i cannot get it to work. I have...

Mike -that solved it, cheers. Thanks Somendra, although it wont alter the dates, i didnt want to drag anything down, as although i only gave an example, i have around 15 tabs like this, so needed a function that would just ignore the ' on the dates. Thankyou for responding to this query everyone.

Ideally I am looking for a solution that doesnt involve altering the dates on sheet 2 - i dont think this is possible in a formula!

Thankyou Mike/Jamir and Satish for you help on this -

Here is a test file - sheet 1 is looking up sheet 2.

Morning everyone - Got a query - basically i am doing a simple vlookup against a date, however the output for the date is coded so it says '26-aug-2014, so when the vlookup tries to find it, because of the ' it returns n/a. Any simple way of getting around this?

Thankyou everyone for your help, problem solved.

Hi all, I have a spreadsheet where on tab 1 is a pivot and tab two is a grand total of that pivot. What i am looking for is a formula that looks on the pivot to see grand total and then cross check it against the grand total on tab 2, and if its the same highlight it in green, if not then...

Thankyou everyone for your help much appreciated - NARAYANK991 you have solved my % issue I was having with your formula as it was giving me over 10 decimal places when i was trying to link the cells. Everyone thanks again, love this forum

Hi thanks for reply, but its giving me a number with 10 decimal places, like 88.01234567 etc - just need it to return 89% and 69%

Hi all i am trying to create the below statement in a text box. The cell refs are a1 for 89% and a2 for 69% - and i cannot create the formula to return the below statement. 89% v 69% last week Any help would be appreciated.

Brilliant thanks Somendra.