desired

Good Day Experts~ Really need a favor and help from all of you. I am trying to do the following graph, but my table is not giving the desired graph. Can I seek your expert advice on how my table format should be to achieve the end results. Thank you very much~ Appreciate it...

Hi, I have the following data: <tbody> Day State Customers 1 NY 500 2 NY 300 3 NY 1000 1 CA 800 1 WA 900 1 OR 200 2 CA 400 2 WA 3000 3 CA 2500 </tbody> I want to rank top 3 cities by customers (regardless of day). Desired result: Top 1: WA , 3900 Top...

Condition: If Credit Note value & Party Name are same then latest date of invoice & it's no should come in desired invoice no & date coloumn <colgroup><col><col><col><col><col><col></colgroup><tbody> NAME Inv No Inv Date CEDIT NOTE Desired Inv No Desired Date A 217975312 03-Jan-17 833743881...

I'm having trouble in getting the Index & Match combination to give me the results I want, obviously indicating that my formulas are incorrect. When I use the formula =MATCH(A12,A11:A1000,0) to search for the position of the value in A12 within the range of A11:A1000, I get the correct answer...

Hi all, In column L, I have the following formula, =INDEX(table,MATCH(G2,INDEX(table,,1),0),MATCH(H2,INDEX(table,1,),0)) I want to add, INDIRECT to it so it can bring the number from the desired sheet, I will put the sheet name on cell G2. How can I do it? Thanks,

Hello - this is my first post on this forum ! I might not be an excel Master, but I do work a lot with it and on pretty complex formulas, but on this one I feel stuck, close to a solution that eludes me everytime :). I have attached a file with the data and the desired outcome. Basically I...

I need a formula to separate and list desired numbers in a certain range from the data i have. For example, if my data is 4,7,15,19,35,41,8,51,56,64,65,71,75,76,42,38 in A2:P2, then if I want to separate and list the numbers between 50 and 59, the desired outcome should be 51,56 in U2:V2. I...

I have a sheet that I want to make very hidden. If someone were to reveal that sheet, I would like code to run to shut the file down My thinking is to put code on the sheet tab that if that specific sheet is visible my desired code runs. Sort of a boobytrap against someone running "show all...

Hi For every row with the value, fetch the table header. I have the following table: <tbody> A B C D 1 x x 2 x x x 3 4 x x </tbody> Desired Result: <tbody> 1 A 1 B 2 B 2 C 2 D 4 A 4 D </tbody> Thank you in advance. Best, AppRoyale

I have a large data set, that is made up of 4 columns. I would like to be able to somehow quickly copy all of the data, and paste it into one column. As an example: Raw Data: B1, B2, B3, B4 C1, C2, C3, C4 D1, D2, D3, D4 ... Z1, Z2, Z3, Z4 Desired format of pasted/transposed data all into one...

Hi, I want the desired result in Z column though VBA <tbody> X Y Z Plan Actual Desired Result 10 10 10 0 20 0 20 30 20 30 40 30 0 50 0 40 40 0 0 50 50 60 0 0 0 0 0 0 0 70 0 80 0 90 0 0 0 </tbody> My code is not working. Kindly help. Sub test()Dim X...

Hey guys, I would like to create a VBA code that simply opens the Save As dialog window (in order to type your desired file name) and saves it as a Macro Enabled Workbook. Thanks

My desire is to return all sequences of non-alpha characters from a range and seperate them by char(10) so they are a list. My intention with char(10) is that I would basically like to be able to return all such non-alpha sequences into a column where each result is in a single cell. If that can...

Hello, I am looking for a clever way to rearrange data in order to be able to import to a financial system (unit 4 / Agresso). The input: <tbody> Activity 201701 201702 201703 201704 201705 201706 201707 201708 201709 201710 201711 201712 Activity 1 5000 5000 5000 5000 5000 5000 5000 5000...

Hi all, I am trying to COUNT the values in a column, but only if they do NOT correspond to a duplicate value in a different column. In other words, only count the Xs for only ONE instance of 101, 102 or 103 in the example below. This is well beyond me and my powers, but could anyone kindly...