a12

Hello Everyone Can someone help me convert below data from: <colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody> JR TR1 TR2 TR3 TR4 TR5 TR6 TR7 TR8 TR9 TR10 TR11 TR12 TR13 TR14 TR15 TR16 TR17 TR18 1 a1 a2 a3 a4 a5...

Hi, I am unable to derive below 2 amounts using SUMIFS. Item code (e.g. C1, A1, A2, A4, A12) cannot be split due they are a cluster. Appreciate if someone is able to enlighten me. Many thanks in advance! <tbody> Item Group Item Code Total Amt (Using SUMIFS) Manual Calculation...

Hey guys. I am trying to write some code to do three things... 1. add a new row at the end of bottom of the sheet 2. copy all formulae with it 3. in column A, add Sequential Numbering I have sussed out the first two but the last one is killing me! to make it a tad more difficult for myself...

1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault? 2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet...

1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault? 2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet...

Hi guys I've been struggling with the offset formula and would like to ask for help I have a serie of values entered on "Sheet 2" that I want to display on a table in "Sheet 1" and I want to be able to apply the formula and use the drag down function I want to be able to enter a formula in cell...

Hello Is it possible to have a formula that will check all the cells at left in the row, find the first cell that is not zero, and use its co-ordinates (eg A12) ? Thanks!

Hi I have a column with the dropdown list option of just blank or "X" for each cell in that column. I want to be able to make it work so that if a cell, say A3 has an "X" in it then all other cells in the column are cleared/blank - Except the Header Line in A1. If another cell, say A12 is...

I want to re arrange my data as follows , if i do manually it will take long , cell reference A meaning on sheet 2 <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> D3 TO A1 E3 TO A2 J3 TO A3 O3 TO A4 N3 TO A5 F3 TO...

Hi everyone, I need help in figuring out a formula. Cell A1 = 2 Cell A2 = 3 Cell A3 = 3 Cell B1 = A Cell B2 = B Cell B3 = D ======================================================================= Example #1 : Now in cell: A6 = 2 A7 = 3 A8 = 3 I'm trying create a formula that will place...

Hi everyone, I have been trying to figure this out, I need a macro to start from a constant cell in a column (Ex: A12), then sum the column down to the bottom (varying length) as in the command+shift+down keystroke, but shorten the sum selection by 4 cells from the bottom. So, for instance if...

Hello, I need in d2 each cell in b:b for as many times as corresponding in column c:c. <tbody> A B C D 1 2 A12 2 A12 3 A13 4 A12 4 A14 6 A13 5 A15 8 A13 6 A16 2 A13 7 A17 1 A13 8 A14 9 A14 </tbody>

Hi, How to do index match with returning unique value. Column A contain code and B contain text. Snap shot attached for your reference. https://www.dropbox.com/s/w1mrqn8x43i26c8/INDEX.PNG?dl=0 Please help me. <colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody> DATA...

Hello, I got this very simple macro that allows user to erase a complete row. It is manually activated by placing cursor in a certain row/cell and executed by CTRL+SHFT+E. Sub Erase_item() ActiveCell.EntireRow.Select Selection.Delete Shift:=xlUp Range("A6").Select End Sub After...

How can I count cells A1:G1 and if it matches the criteria in the correct order then count and put the count number in cell B12. Then look at cells A2:G2 and if it matches the criteria in the correct order then count and put the count number in cell B13 and so on Example: Cell ... A B D E...