• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Check value from multiple rows

    Strange but now it works :). Thanks a bunch!!!
  2. I

    Check value from multiple rows

    Hi PCosta, The array formula does not copy down the other cells. I tried dragging down while holding shift and CTRL as well. The formula remains the same for all cells. What might I be doing wrong? Injinia
  3. I

    Check value from multiple rows

    Hi, I have A set of data as seen in column A and B(master data). I need to run a check for a column G(category), such that the formula checks multiple instances or options of a value from master data and if it corresponds then ok, if not not ok
  4. I

    Extract unique values to one row

    Hi, I need help extracting unique values from a set of data (code 1-code 7) in the sample file. I would like to get just the unique values from the data as shown in the "desired result" Help much appreciated
  5. I

    Extract Upper Case Characters from a cell and Match

    Hi, Sorry for the delayed reply. I got this solved already. Much thanks. -Injinia
  6. I

    extract text between 2 identical characters in a cell

    Thanks alot! works like a charm. Blessings to you too!
  7. I

    extract text between 2 identical characters in a cell

    Thanks alot! This works brilliantly for the second word. I just noticed the "third word" might be a sentence. eg PEAS AT THE SHOP. in this case, it doesn't seem to work. How can I get it to work for the sentence scenario?
  8. I

    extract text between 2 identical characters in a cell

    Hi I would like to extract data between two identical words in an excel cell. The length of the string varies in each cell. The occurrence of the word "or" happens 2/3 times in a cell in my data sample. example APPLE or ORANGE or PEAS I used this formula to extract all words before the first...
  9. I

    Extract Upper Case Characters from a cell and Match

    I uploaded the file
  10. I

    Extract Upper Case Characters from a cell and Match

    Uploaded the sample file. Don't mind the language is not english. some of the cells have the word "OR". This separates the data in the cell as either of the following AMMONIUM DH or AMMONIUM TH or AMMONIUM, LAB ZX, or AMMONIUM, dry or wet. I would only need the product names and these are in...
  11. I

    Extract Upper Case Characters from a cell and Match

    Hello, I have a set of data in one column in a master file as shown below in the sample Product Code Product Name 1326 AMMONIUM, dry or wet 1327 AMMONIUM DH or AMMONIUM TH or AMMONIUM, LAB ZX 1328 AMMONIUM I would like to...
  12. I

    Dynamic Index formula [SOLVED]

    Awesome. Thanks Luke!
  13. I

    Dynamic Index formula [SOLVED]

    Hi, I have a drop down list with months Jan - Dec. The formula below returns the chosen month's figures (I only copied until March ie $BF$2=3). So essentially on one column, I am supposed to get the figures for the corresponding month chosen...
  14. I

    Pasting Data to different cells

    Hi, I have a list of 10 items in sheet 1; A1:A10. in the same sheet B1:B10, I have cell cell locations where the items should be pasted into. In B1 for example, I have about 150 different cell locations between in columns R, S and T. This is the case with each of the other 9 items in column...
  15. I

    text from multiple sheets into one

    Works perfectly! Thanks alot. Regards, Injinia
  16. I

    text from multiple sheets into one

    I forgot to mention also that these 40 sheets are updated every week. -Injinia
  17. I

    text from multiple sheets into one

    Hei, I have a workbook with 40 worksheets, each with the same format. However the text in cells A3:A150 varies. I would like to put all the text from all sheets together in one sheet, so that this new sheet will have all the text in column A. so running from A1:A*** I know that the...
  18. I

    Categorize time stamps.

    And why was I complicating this? Works excellent! Thanks alot!! Regards, Injinia
  19. I

    Categorize time stamps.

    Hello, I kindly need help with the following situation. I have a set of data with about 300k different time stamps. I would like to classify these time stamps based on a 24 hour criteria. Example if the time stamp is 7:42 the result would be 7-8 if the time stamp is 20:30 the result...
  20. I

    Count unique items in a set of data

    Awesome!!! Thanks alot for your help! Regards, Injinia
  21. I

    Count unique items in a set of data

    But how do I count the number of people per day? one person could be recurring a number of times per day but I want the number of actual people on a given day.
  22. I

    Count unique items in a set of data

    Hi, I have a set of data that in the attachment below. https://www.dropbox.com/s/6qb30fpcz7i1cbj/count%20unique%20values.xlsx I would like to count how many people(column C) are available on each day. The data is on about 150k rows. I have done a pivot table for but I would appreciate...
  23. I

    Shorten if formula

    Thanks ya'll!! Regards, Injinia
  24. I

    Shorten if formula

    Hi, Is there a way(or course there must be) to shorten the if formula in the sample workbook attached? https://www.dropbox.com/s/xq2bervsk8y0ea8/If_formula.xlsx Cheers, Injinia
  25. I

    Hi

    Should have done this months ago but better late than never. They call me Injinia, was directed here by google and I have found a new "love" in chandoo(the community) to say the least... Already learnt and still learning alot!! Cheers
Back
Top