| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choose amount appears at first coloums
I need some help.
How to choose amount appear at first coloums for each rows? Lets say I have coloum A-Z and row 1-1000. Each coloums has amount and its appear first time at different coloum for each row. How can I choose amount from the first time its appear? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Choose amount appears at first coloums
Try this array formula
=INDEX(A1:Z1,MIN(IF(A1:Z1<"",COLUMN(A1:Z1)))) HTH Bob "JJ" wrote in message ... I need some help. How to choose amount appear at first coloums for each rows? Lets say I have coloum A-Z and row 1-1000. Each coloums has amount and its appear first time at different coloum for each row. How can I choose amount from the first time its appear? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Choose amount appears at first coloums
Try the below non-array formula...
=INDEX(A1:Z1,MATCH(TRUE,INDEX(A1:Z1<"",),)) -- Jacob "JJ" wrote: I need some help. How to choose amount appear at first coloums for each rows? Lets say I have coloum A-Z and row 1-1000. Each coloums has amount and its appear first time at different coloum for each row. How can I choose amount from the first time its appear? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Choose amount appears at first coloums
If you have default 0's which are to be ignored..then try
=INDEX(A1:Z1,MATCH(TRUE,INDEX(A1:Z1<0,),)) -- Jacob "Jacob Skaria" wrote: Try the below non-array formula... =INDEX(A1:Z1,MATCH(TRUE,INDEX(A1:Z1<"",),)) -- Jacob "JJ" wrote: I need some help. How to choose amount appear at first coloums for each rows? Lets say I have coloum A-Z and row 1-1000. Each coloums has amount and its appear first time at different coloum for each row. How can I choose amount from the first time its appear? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to choose a certain amount of rows and have them ex | Excel Worksheet Functions | |||
| count the amount of times a two letters appears in text string | Excel Discussion (Misc queries) | |||
| Sum the amount of times a number appears in a column in Excel? | Excel Worksheet Functions | |||
| How do I add every other coloums in a linked sheet? | Excel Discussion (Misc queries) | |||
| How to match the Coloums | Excel Discussion (Misc queries) | |||
Linear Mode
