Yes i did see it and noticed that the requirements were changed again, so from a 'fairly easy find 1 number below another' or a far more complex' find...
It not complete, but i think it captures the concept You put the pattern to look for in L to U 1 or 2 rows (note this is a 1 to 10 grid and they ...
It is working. The formula you have put in will colour the cells according to the row number - when you filter the row numbers dont change, you are ju...
Sorry, not understanding what you are after. Can you clarify
I think thiis has the right concept, might need tweaking if you want the break before or after the number =IF(D2=$C$5,$A$5,IF(D2=$C$7,$A$7,COUNTIFS...
I always wonder when i file is named 1-5 that its homework..... Anyway, this is not perfect due to the way you are doing the vlookups based on the S...
What was the formulla?
I would have tried f9 to be fair. Maybe something like this could work? (back up the worksheet first!) Select the range of formulas then run the...
This is the reason we need the example, looking for a number and the number below is easy (as per yesterdays code). But now the numbers can be any ...
PLease attach sample workbook
Can you post some examples so we dont have to guess or make up incorrect data?
I am not sure if its the most efficent, but the below seems to work =PERCENTILE.INC(IF(($B$3:$B$712=B3)*($C$3:$C$712=C3)*($D$3:$D$712=D3)*($E$3:$E$...
Its much easier if you add a workbook instead of screen dumps/text. Try the attached, you need to select the grid you want to check then click the ...
Its much easier if you add a workbook rather than paste in a peice of code Add ActiveSheet.Move before:=Workbooks("OpenFile.xlsm").Sheets(1) after ...
i am sure there will be a much nicer PQ solution, but attached is a VBA one. It will need finishing off but seems to capture the main requirements