| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter a formula in column A, if a condition in column "B" is met
Here is what I am after. I have a large download from a major retailer's
website. Unfortunately, it is not available in a format that is very user friendly to get information from. I am setting up a "database" worksheet to lookup all of the information off of the download, and put it into a format that can be used in a pivot table. What I need to do is evaluate column B, everywhere that STOCK#: ??????, (the ? is a wildcard) then enter a formula in column A. For instance: Evaluate column B Stock#: XXXXXX is found in cell B62 In cell A62 enter the formula =(B62&B60) Then continue on for 2500 rows repeating the procedure wherever "STOCK#: ?????) appears. I would like to thank everyone in advance for looking into this for me. Side note. If anyone knows of any good "Teach yourself VB" books or programs, please feel free to e-mail me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
| how can I count if column A="active" and column E="Job" in a list? | Excel Worksheet Functions | |||
| Use look-up table in Excel and enter into a "county" column, same | Excel Worksheet Functions | |||
Threaded Mode
