YTLE#98: Excel ADDRESS function
Loading...
Loading...
4:31
YTLE#97: 5 Ways To Enter Formula in Excelby ExcelIsFun1,178 views- 2:44
YTLE#99: The Number e in Excelby ExcelIsFun8,075 views
- 8:37
YTLE#100: Array Formula Database Customer Evaluationby ExcelIsFun2,903 views
- 3:45
YTLE#103: Excel Goal Seekby ExcelIsFun12,440 views
- 1:53
Address Validation in Excelby bjhughesfs3,213 views
- 1:36
How to use the OFFSET formulaby MHELP2U6,408 views
- 8:19
Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Troubleby ExcelIsFun7,635 views
- 8:48
YTLE#105: Excel OFFSET for Dynamic Range in Functionby ExcelIsFun21,810 views
- 10:11
YTLE#64: D Function: DAVERAGE DSUM & moreby ExcelIsFun13,612 views
- 2:20
Printing Labels Tutorialby nspeelman13,480 views
- 9:37
How to Hide Your IP Addressby ComputerHelperDude787 views
- 10:01
Highline Excel Class 46: CHOOSE function 4 Examplesby ExcelIsFun12,123 views
- 6:28
YTL Excel #119: Amazing Lookup Solution!by ExcelIsFun17,878 views
- 7:55
YTLE#67: VLOOKUP & DGET functionsby ExcelIsFun9,213 views
- 6:26
YTLE#76: Data Analysis & INDIRECT functionby ExcelIsFun4,447 views
- 6:56
Excel Name Trick #6: Names COUNTIF & wildcardsby ExcelIsFun16,000 views
- 6:50
YTLE#107: Excel Time Across 2 Days Troubleby ExcelIsFun2,196 views
- 8:23
YTLE#84: A Few Data Validation Tricksby ExcelIsFun4,618 views
- 4:27
YTLE#75: DV Drop-Down based on DV Drop-Downby ExcelIsFun8,162 views
- 10:20
YTLE#89: Relative & Absolute Macro togetherby ExcelIsFun5,075 views
Something like this may work:
=ADDRESS(MATCH(MIN(A1:A11),A1:A11,0),1,4)
where 1) the values are in the range A1:A11, 2) if there are duplicates it will only find the first.
ExcelIsFun 1 year ago
I have a column of hundreds of numbers and I need to know the address of the minimum of those numbers. How would I do this?
Thanks
danmackellar 1 year ago
Yes, the formula:
=ADDRESS(ROW(A1),COLUMN(A1),4)&":"&ADDRESS(ROW(D1),COLUMN(D1),4)
will deliver:
A1:D1
ExcelIsFun 2 years ago
Can you use an address in a range? A1: Address(....)
soccerstarmikew 2 years ago