Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with microsoft-excel
Search options answers only
not deleted
user 239790
Questions with this tag should ONLY be about how Microsoft Excel interacts with a specific web application. General questions about Microsoft Excel are off-topic here but can be asked at Super User.
0
votes
EXCEL: If cell x exists in column A then print row 2
To get result use following ARRAY formula in cell G24
=IFERROR(TRANSPOSE(INDIRECT("A"&MATCH($G$22,$A:$A,0)&":K"&MATCH($G$22,$A:$A,0))),"No data")
where "A" and ":K" are your data first and last col …
- 781
0
votes
if cell B4=B1:B2, countif C1:E2=AAA
In your example formula in C5 would be like this
=COUNTIFS(QUERY($B$1:$E$2,"select * where A = '"&B5&"'",0),"AAA")
- 781
1
vote
Accepted
How to get maximum value from rows, only from specific columns
You need following formulas: MAXIFS and MINIFS.
=MAXIFS(A2:G2,$A1:$G1,"bar")
=MINIFS(A2:G2,$A1:$G1,"bar")
- 781
1
vote
I wrongly set the date of 2000 cells. I want to add 20 years of those cells. How?
Try using the EDATE() formula. Since it adds months you'll need 240. Something like this:
=ARRAYFORMULA(EDATE(A2:A2000,240))
Then paste values.
Alternatively, you could use this formula:
=ARRAYFORMU …
- 781