| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
results table dilemma -part 2
hi again,
in addition to my previous post, what formula can you suggest for me to be able to find matching dates and the dates of the week before. thanks, -- "excel newbie" |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
results table dilemma -part 2
"melmac" wrote:
.. what formula can you suggest for me to be able to find matching dates and the dates of the week before. As explained in the response to your earlier post, the criteria could be something like this: In your results sheet, Assume a specific date will be input in A2 In B2: =IF($A$2="","",IF(AND(A!B2=$A$2-7,A!B2<=$A$2),ROW(),"")) Leave B1 empty. Col B is the criteria col. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| results table dilemma | New Users to Excel | |||
| NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Hide part of Pivot Table | Excel Worksheet Functions | |||
| Bold part of formula results | Excel Discussion (Misc queries) | |||
Linear Mode
