order

HI Team, I want to arrange below table in order. If you see the 1st column have all the number. Now in C and G have common number with making of 1. Now i need both them in side to side. Same for others. All the columns should be arranged in order so i can know what are the alphabets have same...

I'm using the Subtotal function, and that works good for what I'm doing, however, I don't need all the extra rows. Without the Subtotal function, I'm manually adding up the duplicate orders and then deleting the extra rows. Example Row 1: route 1 item D4 order 50 Row 2: route 1 item D4 order...

Hello, I've been trying to retrieve some data from an Access database, but I'm getting the above error message followed by 'Syntax error in ORDER BY clause.' Sub LookIntoAccess() 'This macro opens the Database From Excess.accdb database, creates and runs an SQL query. 'Then, it copies...

I have a column with hundreds of dates. The dates are always the most current 5 sequential dates so they change daily. I need a helper column that will tell me which date is 1, which date is 2, which date is 3, which date is 4, and which date is 5 in order of occurrence...

<colgroup><col><col><col><col></colgroup><tbody> ORDER STATUS CAD PENDING DIE PENDING STONE PENDING CAD PENDING </tbody> These are my 4 columns, if (Column 2,Row 2) -> CAD pending cell is blank , then Order status(Column1,Row2) should show CAD PENDING, if (Column 3,Row 2), DYE PENDING is...

Hello Mr. Excel Community - I'm trying to forecast payment date/amount for some payment terms that are more complicated than the usual net 30. Does anyone have any recommendations here for some formulas that are dynamic? Here are some of the payment terms: <colgroup><col></colgroup><tbody> 35%...

Hello everyone, This is my first time posting just as an FYI. I am trying to make a cross tab query that shows Location as the rows and Week Number as the Columns with a value set up in builder. Where I'm running into an issue is that in order to get the accurate value, I need the distinct...

I have a list of Invoices with a Date and Email Addresses from a sales database. I have counted the number of invoices per email address...but now I need to mark each invoice as "First / Second/Third, Fourth, Fifth Order .. basically what sequence.... I am trying to calculate the number of...

HI All, I am trying to create a calculated column using an if/and DAX statement in PowerPivot and for some reason I keep getting errors so I am not sure if its the formula or if I am completely unable to perform what I want. My formula is below, can someone please help =IF(([Actual Order...

Hi Everyone, i'm looking for some advice. i have a workbook which i use as my invoicing. Before i save the workbook i would like to copy the data from different cells lets say A5,B9,C1,R4, and a few others into a master workbook on a row, but all on one line as order one & the same for order...

I have a sheet of about 1000 rows ... So there are 11 rows of Master Order numbers but only 5 different Master Orders. Some Master orders have Slave orders, some do not. If a Master order has a Status of 12, 13 or 14 or a Type of 02 I need to remove that row. The problem Im having is...

Alright guys, I'm pretty new to VBA and am working on a fairly simple userform to display data from multiple sheets in one place. I need help with one aspect, I need to convert days of the week to actual dates. The trick is I need to find the next available day of the week based on today's...

Hi all, Hope you can help. Think i'm doing this correct but isn't working i think because of dates. My table is A2 to P5000. I was using =COUNTIFS(E:E,T3,P:P,1) Column E:E is dates during the year, Column P:P is number of days which is a calculation between order recieve and order due. T3 is...

I have a spreadsheet where a whole team enter data, and it's often not in date order (e.g. Mary enters 15th October, then Sally enters 7th October further down etc). On a separate sheet I would like to automatically list under each month the dates that have been scheduled, but in date order...

Hi, I just opened my Excel workbook and noticed all my DAX measures that were sorted into columns are now in a random order. I've seen this before and moved them only to find them just thrown back into a random order. Any thought how to sort them again and avoid this. Thanks

Hello, I have a list of form numbers that are in random order (see below example). Is there an excel formula that could check the entire column, only look at numbers starting with IAF and determine what the next form number would be? IAF 1234 IAF 1201 IAF 1300 IAF 1001 So it would return: IAF...

Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks

Hello, I have a tedious task of reviewing data in a piece of software. I only need two pieces of data in order to do my review, but there are a lot of data that show up. I only need the data shown below (data are fictional): <tbody> xxxxx08a.p 7.8.50...

I have a pivot table with a ****load of fields. It would help if I could insert calculation fields within the pivot itself rather than doing it externally. With the data below I'd like to create a field which shows the Profit per Order and the Shipping Cost per Order. I went to the Analyze...

Column A is 5 digit Order Number Column B is Customer name Columns C thru O are X’s or 0 depending on which stage Order is in. Using VBA to set conditional formatting for C thru O columns With ThisWorkbook.Worksheets(1).Range("C3:O3") .FormatConditions.Delete .FormatConditions.Add...