-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
small()
-
M
Index Array with Double If Argument
Hi, We are trying to build a formula to analyze Amazon Ad Campaign Data. We have 2 sheets. The first is a raw data sheet where we paste the info in. The 2nd is a bid adjuster sheet which calculates based on the raw data info Our Auto Campaigns are working and look like this: Raw Sheet...- mco5044
- Thread
- array() if() index() small()
- Replies: 6
- Forum: Excel Questions
-
D
Using Index with nested small, not updating when I insert row of data on the reference page
Hi, I have this code that looks to my sheet with Cash Flow Transactions, and returns values associated with the date range (O7 = beginning date), if not it returns the period end date (P3). When I insert a row in my Cash Flow Transactions Page the formula does not update for the new row (instead...- dpnyc
- Thread
- iferror index range small()
- Replies: 0
- Forum: Excel Questions
-
G
Combining "if", "Large" and "small" in the same formula
I can not seem to get the formula correct for the following scenario. If any number in column a, rows 1-3 is greater than zero, return the largest number. However, if the numbers are all less than zero, return the smallest number. I tried =IF(A1:A3>0,LARGE(A1:A3,1),SMALL(A1:A3,1)). I continue...- greg m
- Thread
- if() large() small()
- Replies: 6
- Forum: Excel Questions
