Search results

Sorry just realized it needs to be VLOOKUP(A2, TABLE with sku and cost, 2, false) with 2 being the column cost is in but I get an error about a circular reference and it doesnt work

I'm trying to use a VLOOKUP funtion and having issues getting it to work. I have a column of product skus and I want to do a VLOOKUP into another sheet to grab the cost. In the other sheet I have 2 columns the sku and the cost. used: VLOOKUP(A2,SHEET2 COLUMN A2, A3, not sure what to put) A2 in...

It didn't find anything. I'm not sure if û is a carriage return but I thought it was.

I tried Ctrl+J and it didn't work

Im trying to search through an excel find to find all of the carriage returns in a field. ex: HARRY S TRUMAN NATIONAL HSTRC SITEû223 N MAIN ST I need to have each line item with a carriage return marked so that I can have them fixed in my database. So how could I create a function or just...

I know there's a way to create a calculated value in a pivot table but I can't remember how to do it or if my data for the pivot table is set up correctly for this.

I have a pivot table with the sales of 100 different products over a ten year period. The sales for each year are in a different column in the table that's being used so that when I make the pivot table I can put 2010 vs 2011 next to each other. Now is there anyway to create a column next to...

I have a pivot table for sales by car parts for the different manufacturers of cars. In the filter there is a category for the manufacturer of a car(ie Honda, Ford, ect) and then I have the car part(ie suspension, brakes, engine, ect) also as a filter. I would like to be able to combine...

I'm trying to remove all of the carriage returns in excel but keep running into a problem where some still seem to exist. I've tried: =SUBSTITUTE(A1,CHAR(13),"") =SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),"<br>","") =SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),CHAR(10),"") But I am still getting some...

just changed it to word wrap with my original formula and it sort of worked. After notes one it creates the line break and inserts the information from the first cell but then the next two notes sections it doesn't create a line break. The data is just next to notes2 and notes3. can someone...

its not making a line break, everything stays on the same line

I am trying to combine 3 cells per line and use the char function to have a line break between each of those 3 cells in their new combined cell. I tried: =(CONCATENATE("Notes1 ", CHAR(10),N2,CHAR(10),"Notes2 ",O2,CHAR(10),"Notes3 ",P2)) For an example on how to make it work please use cells...

that worked thanks I also found another way messing with it if I just use InStrRev() to find "-" and then using midpoint and using -2 on what the InStrRev() string returns

Not every item would have 4 characters after the last "-" which is the problem

I'm trying to find a function in excel or even access that could do the following: ZAB103-3012 ZAF405-HD-0001 Turn those cells into: AB103 AF405-HD Pulling everything to the right of the Z in the last step is the easy part but I can't figure out what function would be able to find the...

If i have "" that symbol multiple times within the cell but I want to pull everything right of the last "" how would I do that. example: thehappy_housegrey.jpeg basketballnbatitlethebostonceltics.jpeg

Product Group Week30 Orders Week30 Qty Week30 Sales Week31 Orders Week32 Qty 1 15 1000 15000 8 450 2 1 5 30 6 50 3 9 40 1000 2 2...

I want to look like that except that the columns would be the count and sums for each week sorted by week number so that each week is grouped with itself

How do you sort it so that each of the 3 sigma values for every week are next to each other instead of have week 1-30 for the count, then week 1-30 for the sum of qty, then week 1-30 for the sum of sales?

I'm pulling all of my orders with the order date and exporting it into excel. The orders start in December 2011 and go till July 2013. When I run the weeknum function using Monday as the start date for the week it gives me 53 weeks in the year for 2011 but starts 2012 on week 2. Does anyone know...

Week Number Product Group Order Number Qty Sales 31 4 SO743 3 45.98 31 4 SO899 18 109.52 31 5 SO122 4 62.31 30 2 SO312 1 31.50 So for each week I want to be able to count the...

I have a pivot table and with in my data for product sales I have each week that an order occurs. I would like to be able to show each product group by week the number of orders, total qty, and total sales for that week that occurred. If I do just the sales by week then the table looks perfect...

thank you Sara, that worked.

I have a list of items, the description of the item, number of orders, quantity and sales for each item. How do I get the description of the item to appear next to it instead of under it. Also, my orders quantities and sales are appearing twice. How do I fix that? please help thank you

Ohhh ok I didn't realize you had to pick the cell within the worksheet. I was just trying to assign it to the sheet I wanted. thank you