a13

  1. C

    Find Data below Black Cell from Known Cell Below

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

    Max amount within a range

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

    Restrict Excel data in two columns VBA Skills Required

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

    Data arrangement macro

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

    copy down based on value

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

    how to count quantity for multi-BOM

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

    Skipping Cells

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

    Any way to auto-hide rows without using VBA? Conditional formatting?

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

    VBA to Change Axis formatting on Chart

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

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top