This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I'm trying to use the Sort and Filter functions to return the first row only, instead of spilling everything over. And if possible, return just one specific cell actually. The formula I have is:
SORT(FILTER(Agents!$H$2:$U$32,(Agents!$P$2:$P$32>0)(Agents!$S$2:$S$32=TRUE)(Agents!$U$2:$U$32=TRUE)*(Agents!$N$2:$N$32>1),"Fack"),8,1,FALSE)
Ideally, I would only like for it to return the first row -- and even more ideally, I would like for it to return the cell in the 1st row, and 3rd column. Any help would be much appreciated!
I've tried OFFSET, but that doesn't seem to work when referencing the SORT/FILTER within the same formula. Though, it does work when I use the OFFSET as its own standalone formula.
Thanks!
Post Details
- Posted
- 5 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...