Recent content by uul

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.