Forum Discussion
Solved
Formula help please
I have a sheet with a year of (365) dates in Row 1 starting in cell B1 Under that is a list types of incidents in column A The requirement is to look through each day per incident type to find the ...
=TAKE(FILTER($B$1:$NC$1,B2:NC2<>""),,1) =TAKE(FILTER($B$1:$NC$1,B2:NC2<>""),,-1) =INDEX($B$1:$NC$1,AGGREGATE(15,6,COLUMN($B$1:$NC$1)/(B2:NC2<>""),1)-1) =INDEX($B$1:$NC$1,AGGREGATE(14,6,COLUMN($B$1:$NC$1)/(B2:NC2<>""),1)-1)
=TAKE(FILTER($B$1:$NC$1,B2:NC2<>""),,1)
=TAKE(FILTER($B$1:$NC$1,B2:NC2<>""),,-1)
=INDEX($B$1:$NC$1,AGGREGATE(15,6,COLUMN($B$1:$NC$1)/(B2:NC2<>""),1)-1)
=INDEX($B$1:$NC$1,AGGREGATE(14,6,COLUMN($B$1:$NC$1)/(B2:NC2<>""),1)-1)
Hello, I have another question.
I have a simple spreadsheet with three columns
Date1 Date2 ChosenDate
The cell ChosenDate needs to show the earliest date of Date1 and Date2
I thought this would work =IF(Date1<Date2,Date1,IF(Date1=Date2,Date1,IF(AND(Date1="",Date2="","none"))))
But it doesn't work. Any clue?