-
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.
henry
-
Q
Non-Array Index Lookup (first not blank)
I have a working INDEX lookup function using an array, however due to the data size it takes too long to produce results using arrays { IFERROR(INDEX(Notes!$B:$B,MIN(IF((Notes!$A:$A=$A2)*(Notes!$B:$B<>""),ROW(Notes!$A:$A)),9^9)),"") } This will lookup lookup cell $A2 in Notes!$A:$A column...- qlander
- Thread
- andrew cell column henry lookup
- Replies: 3
- Forum: Excel Questions
-
K
MEDIAN with multiple IF conditions
I need to write a formula that calculates a median value, with several IF clauses. EG 'data' tab is below: <tbody> Person Sales Margin Tommy 2 100 Jimmy 3 300 Henry 5 500 Jimmy 4 200 Jimmy 6 100 Tommy 10 200 Henry 3 700 Henry 5 1000 Tommy 7 500 </tbody> In another tab, I...- Ken Soona
- Thread
- henry if statement median median if tommy
- Replies: 3
- Forum: Excel Questions
-
G
Conditional Copy/Paste Macro
Hi all I currently have some code that copies and pastes rows, a variable number of times dependant on data in Supervisor Name field, to a new sheet. What I am looking for is a way of adding a cell prior to the pasted data, populated with 'Call 1, Call 2 etc. which references the number of...- GrahamVincent
- Thread
- bob brown henry macro - copy/paste smith
- Replies: 5
- Forum: Excel Questions
-
H
VBA Error "Object does not support this property or method"
hello everyone: I am a certified excel expert but kind of new to VBA world. I have a simple VBA code but keep getting the error message "Object ......" Sub test() ThisWorkbook.Sheets("Henry").Cells(Rows.Count, 1).End(xlUp).Row End Sub I have an excel workbook with a worksheet name called...- Henry1
- Thread
- error excel henry vba
- Replies: 2
- Forum: Excel Questions
