Search results

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...

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...

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...

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...

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...

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?

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...

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.

Hi all, Got a query with a two way lookup - I have attached the screenshot above. Basically I want to do a lookup where it looks for attack - then moves to the right to find say defend, then gives me the number equivalent to attack, so in the case above it would be number 3. I am currently...

Hi, I have this spreadsheet below that is using offset to select a category, but i want to return the row of data under fixed date headings when that category is selected. Any idea's? https://dl.dropboxusercontent.com/u/33482140/Rows.xlsx Any help would be appreciated.

Hi guys -A quick question, but does anyone know why when i go to linked pictures after following chandoo guide on dynamic charts etc it is greyed out. I can link pictures from one workbook to another but not on the same workbook? im using excel 2007 and its driving me crazy! thanks Steve