order

Hi - I have in A some order numbers and D has dates. A will populate blanks below row 1 until a new order begins and then enter a new order number followed by blanks dependent on how many lines on the order. D has 2 different dates. I want to be able auto fill the blanks in A (already solved)...

Hi - I have in A some order numbers and D has dates. A will populate blanks below row 1 until a new order begins and then enter a new order number followed by blanks dependent on how many lines on the order. D has 2 different dates. I want to be able auto fill the blanks in A (already solved)...

This seems quite simple to me but i'm a bit rusty and i just cant figure it out. I have a table full of orders (which gets added to) with order number/garment type/design type/fabric colour/printing colour/size eg: 10000001/tshirt/frog/green/black/XL i want to order them, starting with the...

Hello MrExcel gurus, The title of this post has the jist of my question, but here's a bit of background: I'm trying to optimize a very bulky financial model. I've got calculation time down to a couple seconds or so, but I'd like to isolate the specific cells whose calculations are still...

Hi, I am wanting to be able o se the values behind a trend line I am using on one of my graphs I can get this to work for order #3 using a formula I found on one of these forums, however when I try and adapt it to work for order #4 the results it give me are different to the trend line

So I have been having a mental block when trying to figure out how to have excel do what I want/need it to do. Basically I have a main sheet called “directory”. It accesses all other sheets via buttons. On this sheet I have a drop down list of order numbers based off the day selected. When...

Hi, Excel beginner here and I am trying to create a form with checkboxes that when checked create a text output into a single cell. I have been able to create the checkboxes and get the formulas to work so that all of the text outputs combine into a single cell using the concatenate function...

I have three columns, 1st column has Sales peoples names in it, second column has type of order and third column has the total of the order I would like to look up all the orders for John Smith, that have been won and total the value of the orders. I was using sumifs and its not working, is...

Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details. I am stumped not sure whether I'll need to use helper columns / vba. I wanted to get the answers to the "To...

Re: How to find the most SEQUENTIAL occurring numbers in 1 column how do i sort the numbers in a row in numerical order?For example the data looks like this and starts at C2 (I re-sorted it), so how do I get the data to read "1" on L2, "4" on M2, "10" on N2, "18" on N2, and "26" on O2. All of...

I changed the column order on my query and when it loads to the data model the columns are in the original order. My expectation was that I you change the query it's reflected in the data model. Help!

=IFERROR(IF(INDEX(AIMS[NDC BOM Status],MATCH([WMS Order ID],AIMS[[#All ],[BOM Order'#]],0))=0," ",INDEX(AIMS[NDC BOM Status],MATCH([WMS Order ID],AIMS[[#All ],[BOM Order'#]],0)))," ") What does the #All do?

hi i have two spreadsheets downloaded from separate systems. the first list has order number and an amount the order number is on each list multiple times with different values for item ordered. the second list has the same but some of the values are different how can i do a search to find...

Hi I am hoping someone can help. Looking for a formula to use on a large excel sheet to rearrange the characters in a specific order. The following is an example. "1f6f33b9-35bc-6d4b-8377-ca5fc024eae1" to change to "b9336f1f-bc35-4b6d-8377-ca5fc024eae1" Basically the first set of 8 characters...

Hi I am creating an excel where in 1 sheet I will take lets say the order: i.e: Date, Customer Name, Product Code, Qty and on the sheet 2 I will have on the A column all the products and on A2, A3,A4, A5 .. all the customers. What I want to do is to be possible the Sheet 2 to read from Sheet 1...

Hi - looking for help I have MI on 3 tabs which I want to easily Copy and Paste into a master tab in month order please https://drive.google.com/open?id=1Q5...1aVd313i3gGa-Z

Sheet1: <tbody> 1 Cat 2019-05-21 Error... This, this, and this 2 Dog 2019-05-21 Error. This, this, and this 3 Mouse 2019-05-25 In order - that, that, and that 4 Fish 2019-05-26 Where, when, why, and how </tbody> Sheet2: <tbody> 5 2019-05-22 Dog ... 6 2019-05-22 Fish ... 7...

Hello guys, I hope you can help. I have a sheet that basically has names and scores, the names are in cells B3-B10 and their scores are in cells Z3-Z10. This is part of a scoreboard with other bits in between them so everything needs to stay where it is, however I would like to put a live 1st...

Hello, I need someone to help me to find the best and fastest way to align data in Excel Sheet. 1) I have the names in column A fixed and always in the same order. 2) I have the same names in column C but their order changes all the time. 3) I have budgets in column D that each number is...

I'm trying to create a macro that will do "one to many matches" and output them to a report. I cobbled together a very rough macro that sort of works but not really as requires range values to be manually changed each time. Ideally, I'm looking for a macro that will loop through, match and...