Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Excel # and JPEG Names
I have a listing of products in Excel.
For about 50% of those items I have a JPEG that uses the item # as the name of the JPEG. I need to create a list of items numbers that do not have an associated JPEG. Is there a way that I can compare the JPGS that reside on my hard drive against the Excel listing? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Excel # and JPEG Names
Edit.... .... -- ExcelChampion ------------------------------------------------------------------------ ExcelChampion's Profile: http://www.officehelp.in/member.php?userid=5096 View this thread: http://www.officehelp.in/showthread.php?t=1267203 Posted from - http://www.officehelp.in |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Excel # and JPEG Names
Well it cannot get any easier than ".... ...."
"ExcelChampion" wrote: Edit.... .... -- ExcelChampion ------------------------------------------------------------------------ ExcelChampion's Profile: http://www.officehelp.in/member.php?userid=5096 View this thread: http://www.officehelp.in/showthread.php?t=1267203 Posted from - http://www.officehelp.in |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing Excel # and JPEG Names
I have a listing of products in Excel.
For about 50% of those items I have a JPEG that uses the item # as the name of the JPEG. I need to create a list of items numbers that do not have an associated JPEG. Is there a way that I can compare the JPGS that reside on my hard drive against the Excel listing? This is far from elegant, but such things have worked for me. Using the "DIR" command-line command in Windows, get a textual list of file names. Then paste the list into Column A of a new worksheet. Then use a formula in column B to extract just the file names there. Use MID(...) or LEFT(...) or whatever. Also use IF(...) to get an empty cell for lines that don't have file names in them. Now go back to the "listing of products" sheet and use COUNTIF(...) or similar to match with column B of the new sheet. When things are updated, overwriting Column A of a new worksheet with a new list should update things. The formulas should all continue to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create 50,000 drawings in Excel and export to jpeg | Excel Discussion (Misc queries) | |||
Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats | Excel Worksheet Functions | |||
How do I view a JPEG file from data selected in Excel | Excel Worksheet Functions | |||
I want to set up a form in excel where I can place a jpeg or pic. | Excel Discussion (Misc queries) | |||
insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) |