primer

  1. S

    Lookup multiple values in the same column (I think this is what I'm looking for)

    Hi everyone, I'm quite new to excel and have been trawling the internet and YouTube for answers but couldn't find what I was looking for exactly. So I have a transaction sheet from Amazon for accounting purposes. All I want to see is how much I had made per item. However, the way Amazon show...
  2. M

    INDEX MATCH wont return first match in a column

    Hello all i am stumped with this but this formula always returns the last * character in a list {=IF(A2=""," ",INDEX(F2:F18,MATCH(TRUE,EXACT("*",E2:E18)),1))} so regardless of the range i choose i always get the bottom result, in this example: <tbody> Bodyshop/Adhesive & Sealant always...
  3. muhammad susanto

    Data Validation With Unique Drop Down List

    hi all.. i have the data this below : <thead> Group Class Type </thead><tbody> Inner I Arteri Inner II Arteri Inner IIIA Arteri Inner IIIA Kolektor Inner IIIB Kolektor Inner IIIC Jalan Lokal Outer I Arteri Primer Outer I Kolektor Primer Outer I Arteri Sekunder...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top