a13

Hi, Just looking for a solution if possible I have a known cell but I would like to return a value of a cell above just below an Blank Cell A1 Text 1 A2 Text 2 A3-A11 Data 1 to Data 9 A12 Blank Cell A13 Required Data A14 Text A15-A22 Data 1 to Data 8 So A19 is Known but I need to...

Good morning. I need help with the following, thank you. There are 2 columns: ID and rate. Some IDs are repeated, sometimes 3 times, 5 times, 9 times etc. I need to pick the highest rate for each ID and there are over 20,000 IDs. I tried DMAX but didn't seem to work. Thank you for your help...

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...

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...

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>

Hello, I need a help to get Multi-quantity for multi-BOM, example: actually in Multi-BOM, A3 need 4pcs Layer. No. Qty Multi-Qty 0 A1 1 1 A2 2 2 A3 2 3 A4 1 1 A5 2 2 A6...

Hi This seems quite simple but I can't seem to find a way of doing it or the correct terminology to search for it. But basically I have the following 2 Sheets On sheet 1 I need In cell A10 = Sheet 2 A8 In cell A11 = A10 In cell A12 = A10 In cell A13 = Sheet 2 A9 In cell A14 = A13 In cell...

I know how to hide rows using a Worksheet_Change module. But, the end user is worried about the workbook being file type xlsm. So, looking to avoid a macro solution if at all possible. Bottom line ask: user fills in Cell a13 with a certain value. Based on the value in Cell A13, if the value...

I have a table which will displays data based on cell A13. A13 = "A" then Number format A13 = "B" the % format From the table I have created a Chart, Which is fine when the data is in number format. Is there a way to change the format to % (and limit max range to 100%) when cell A13 is "B"...