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

    Vlookup and sum multiple values in the same column

    Hello, I've been searching multiple sites for a solution to this problem. I'm trying to lookup similar Text in column A and return the sum of all corresponding values in column J. I find vlookup is good for finding a particular value when the text is only found once in a column, but i'm...
  2. R

    Trying to paste a column on the left and automatically place a category to right

    Hi, I've looked all over for an answer for this and can't find any. I'm not sure it can be done. Here's and example. On the right i'm trying to come up with a formula that looks to the name on the right and puts a category name on the right of it such as Automobile and Groceries...
  3. R

    Look for a restaurant in one column and add Dining in an adjacent column?

    Hi, I'm not sure where to even look this up. Thanks
  4. R

    How to use SUMIFS to determine all John sales from one reference date?

    Hi, I found a lot on adding sales between dates. But i would like to add sales from one date as a reference. I'm trying to formulate the sum of and extract all "John" sales since a beginning date. And then separately, sum all of his sales older then 14 days before the beginning date...
  5. R

    How to use SUMIFS formula where the 2nd criteria is in a single cell?

    Hello, I've searched the forum for examples of SUMIFS formulas. There's a lot on adding the total for a column when the criteria for two columns meet. But I'm trying to add a column when one criteria is in an adjacent column and the other is in a single cell on the same spreadsheet. Any...
  6. R

    Calculating catagory totals for a budget

    Hello, I would like my spreadsheet to look for and total all Groceries and Gas & Fuel into 2 separate cells as i paste my banking transactions into a range of cells. Is it possible to automatically add all my Groceries and Gas & Fuel category's, respectively, using a function or Conditional...
  7. R

    Is it possible to format A1 red if A300 is shaded red?

    I'm trying to highlight the top of a schedule when a red cell at the bottom of the spreadsheet turns red.
  8. R

    How to auto shade A1 red if B1 is shaded red?

    Hello, Is this conditional formating? Thanks
  9. R

    Is there a search box for this forum? :)

    Hello, I love the tags to the left, but a search option would be more specific for trying to find an answer before i post a question. How do i find my favorites for this forum? Thanks Mark
  10. R

    Possible to have values follow days of the week in a monthly column calendar?

    Hello, Is it possible to have numbers or alph/num follow the days of the week in an adjustable monthly column calendar? As i change the month the days of the week correspond to the dates of the month. Can i have certain values follow every Monday as i change the month...
  11. R

    Monthly work schedule, disappearing assignments

    Is it possible to start with the value "A" in a cell and then add the same value in another cell while automatically removing or hiding the original "A"? In other words, I'd like to start with a group of values on one line and then as I use the values on another line, I would like the original...
Back
Top