| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert to VB
SH*T. Can someone please write this in VB for me because when i drag this down 20, 000 rows and 10 columns across.....I get quite the file. Can you make it so that it says N/A for ones that it doesn't find. Id like to be a macro that i just run that does it for me "real quick". =IF(Code1=ifthen.xls!CODECOL,INDEX('[ifthen.xls]Final Merge Fields'!$1:$65536, MATCH(A47947,'[ifthen.xls]Final Merge Fields'!$A:$A,0),MATCH("Code",'[ifthen. xls]Final Merge Fields'!$1:$1,0)),"") -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200507/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert PivotTable data into a worksheet list | Excel Worksheet Functions | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
