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

    Check If Entry Exists: If Yes, Update. If No, Create?

    Hey Luke, Thanks for your help. Looking at the tools, I don't think there is on there that meets my needs? All I have in that option is "Summarize with pivot table" and "Remove duplicates"? The sheet that will have all the data is called "Data", and Row 1 are the headers. Rows 2 and onwards...
  2. M

    Check If Entry Exists: If Yes, Update. If No, Create?

    Hey all, I have quite a particular problem and I'm sure you guys can help. I did run a search, however its quite a specific problem so I wasn't able to get any hits. The problem is as follows: We have raw data entered into a sheet called "Data". This information is updated weekly, and tracks...
  3. M

    Most Common Text Value

    That worked like a charm, thanks Hui! Problem solved :)
  4. M

    Most Common Text Value

    Hi all, Just a quick question (I have done a search, and wasn't able to find a working finished post) about finding the most common text value in a column? For example, I have column J, the entirety of J (can sometimes be 1-100, sometimes 1-500) filled with varying strings of text. Job...
View older results
Back
Top