order

Goodmorning everyone In the attached file the data of our interest are in column A and column D where there are data, even repeated and empty cells. The aim is to obtain a unique and alphabetically ordered list of the two columns without the use of service columns. Expected results are in...

<tbody> Order Date Type Order Status Cost 2019-07-01 Bulk Completed $5 2019-07-09 Parcel Shipped $7 </tbody> I need to figure out the weekly shipping costs for Parcel packages. At the moment I'm doing it manually because I can't figure out how to write a sumif statement with a range of...

Hi, I am hoping someone can help! I am trying to set up a spreadsheet for an online business that updates the 'cost of purchase' depending on which stock order has been sold. For example, if I order 10 units of soap at $10 then the cost is $10. If I make a second order of 10 soaps at $12...

II am trying to extract all data that has dates in Col 1 from multiple sheets to one master. I would also like to make that master sheet in date order and have it auto sync whenever I add anything to any of the sheets. I tried to follow a video, but it didn't work. Here's the formula I was...

Hi I am trying to update values in an inventory sheet but if value has no change then i cannot create a formula to show the previous value. Any help would be appreciated. Hope this makes sense. thanks MC cust1 has starting value of 100 cust2 has starting value of 200 Thanks <tbody> date...

My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots. SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are...

<tbody> remaining Old Contract Credits 10 Price 30 New Contract Credits 50 Price 25 Out of contract (no credits) Price 35 Remaining Credits 60 </tbody> Order <tbody> order 1 number of books order 2 number of books order 3 number of books Book 1 2 2 2 book 2 3 40 0 book...

Hi all. I am trying to show combboxes on userform to display the data, say customers, in alphabetical order. I have found the code bellow on MrExcel but it's not working. I am getting run time error 13, type mismatch. Private Sub UserForm_Initialize() ufcbbname.SetFocus allowed.Text...

Hi Everyone. I am trying to create an error inclusive training in excel for my research, and would love your help to collect as many beginners errors as possible- those you see the most often - whether it is with formulas, functions or else. The below list is what I compiled based on online...

I have a table that was generated from an update query. The table is just one column containing either numbers or just being empty. They are also sorted, so the empty cells are on top, numbers are sorted. Numbers range from 1 digit to 5 digit numbers. I open the table in Design View mode...

Hi, I've managed to find some VBA code on Google that will automatically order my data (below), but it's not quite what I need. I'm looking at entering a job number in column A, an order in column B and then text in column C. Once the text is entered in C, I'd like my data to automatically...

I created a Power Query table that has columns for Order#, Order Item#, Part#, Quantity, Item Value, Customer, Address, Order Status and Order Date. I see that the "Subtotal" menu option is greyed out. How to subtotal Item Values by Order# or by Customer like I would in a regular Excel...

Hi, I would like to show months 1 2 3 4 5....12 from column K to V in a pivot table, but the pivot is not sorting them from from 1 to 12 but keeps showing as 2 3 4 5 6 7 1 8 9 10 11 12. I can't get the 1 to go before 2 so in correct order. I've tried to drag the column to front of 2 but it...

Below is the beginning of my code, the only issue I'm having is that the below list when deleting should only delete on an exact match. So for example if I have 'carrier name' as a column header and 'carrier name 2' as a column header by the list below only carrier name column should be...

I use the following VBA code to sort a list of dates in ascending order. Range("A1:B10").Sort Key1:=Range("A1"), _ Order1:=xlAscending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom The problem is that in some cells in the date column, the...

Hi, I would like to create a formula where if I have sold more than 6 quantities and I have less than 3 in stock, it would ask me to create an order for 12 quantities. Thanks in advance. Regards, Hiten

Hi, I'm trying to match actual orders to budgeted orders. Column A: Part number Column B: Actual Order Qty Column C: Display Part Number Most of should be the same as part number in column A, but not all of them map. Column D: Budgeted Order Qty I would like to add a column to show for...

I created a table to record ordering items, and have 2 columns (a Date, and a Qty) for each week of the year, per quarter, to record the Date Ordered and Quantity Ordered. I have 2 columns (at the end of each quarter) which I want the Last Date Ordered to appear in one column, and Last QTY...

I have two tables, sales order and purchase order. The only way I know how to do a vlookup is to create a helper column to use with my lookup (username&date&qty&itemno). 90% finds a match, but for the 10% either, the username or date (it could be 1 day after or 1 month) or qty is different...

Hello everybody, have you ever met situation when Excel columns go from right to left (column A is first from the right) but data are ingested from left to right (January is in column L, December in A). If I just copy and paste all data I have wrong order. How can I reverse order of columns? Can...