Search:

Type: Posts; User: Toadstool; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    99

    Re: Search multiple criteria for item

    I cannot diagnose without seeing what you have (maybe a missing $?) so if you can't provide your spreadsheet then please supply the headings, old and new tab names and the first AGGREGATE formula in...
  2. Replies
    7
    Views
    99

    Re: Search multiple criteria for item

    Nanaia,

    I'm not sure I understand "the item in the old row 14 does not correspond in any with with the new row 14" as the new row 14 has no data in my example.

    I understood you wanted to take...
  3. Replies
    7
    Views
    99

    Re: Search multiple criteria for item

    If each dimension is a column:


    <tbody>

    A
    B
    C
    D
  4. Replies
    7
    Views
    99

    Re: Search multiple criteria for item

    Hi Nanaia,

    I think this is what you want...

    Here's the "Old" tab with parts and dimensions:


    <tbody>

    A
  5. Replies
    5
    Views
    107

    Re: Return Lookup based on range cell

    You don't specify what to do if the number of days exceeds 14 so I'll assume they get one more discount point.

    The 3-7 and 8-14 are tricky to decode so you can just use the bottom end of the range...
  6. Re: Automatically typing the whole list by the list name

    Nobody will be able to access images on your desktop.
    Try and copy then paste text from your sheet.
  7. Re: Automatically typing the whole list by the list name

    Please supply an example of your data.
  8. Replies
    4
    Views
    98

    Re: Difference in date

    You're welcome!
  9. Replies
    4
    Views
    98

    Re: Difference in date

    Change the $20 to whatever is your maximum row.


    <colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
  10. Re: Conditional Formating Required for changing Dates based on 2 different cell dates

    Hi salsy,

    You have three colors so you'll need three rules. The red, green, purple rules are:

    =AND($A2 <> "",$A2 < TODAY(),$B2 < TODAY())

    =AND($A2 <> "",$A2 <= TODAY(),$B2 >= TODAY())
    ...
  11. Re: Help! Trying to pull historical employee data based on a date range.

    Hi livesmiley,

    You don't say how many rows of data you have so I'm checking every row on the sheet. The formula will run faster if you limit the row range.

    Here's the historical data sheet. No...
  12. Re: HELP! Formula to identify text in one cell and group in in a new tab?

    You're welcome!
  13. Re: HELP! Formula to identify text in one cell and group in in a new tab?

    I thought I should provide some explanation.

    Monday is Sheet 2 so =TEXT(SHEET(),"dddd") shows the second day of the week, Monday.

    The...
  14. Re: HELP! Formula to identify text in one cell and group in in a new tab?

    Is this what you're looking for?

    Here's the first tab called "Data" which has a list off to one side for the LoV selection of each cell. There's no formulae here, just the Data Validation entries...
  15. Re: HELP! Formula to identify text in one cell and group in in a new tab?

    Hi nskinner821,

    Q. By "In the rows/columns I have a selection of 5 different activities the students will be participating in that day." do you mean each student has one activity for each day of...
  16. Replies
    2
    Views
    107

    Re: Project Overview

    Hi Chris86t1,

    Is this what you wanted?

    Here is the tab with my sample data:


    <tbody>

    A
  17. Replies
    7
    Views
    285

    Re: Extracting data

    Use SUBSTITUTE "T" for null and check before and after lengths.


    <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>

    A
    B
    C

    </thead><tbody>
  18. Replies
    3
    Views
    181

    Re: Wrong result when using

    You're welcome!
  19. Replies
    3
    Views
    181

    Re: Wrong result when using

    Are you sure you want

    "<>C2"
    and not

    "<>"&C2
    ?
  20. Replies
    8
    Views
    249

    Re: Counting Columns of x

    How about:


    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
  21. Replies
    1
    Views
    89

    Re: Make the lowest value a 0

    Is this what you want?


    <colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>

    A
    B

    </thead><tbody>
    1
  22. Replies
    3
    Views
    175

    Re: Date ranges in excel

    You didn't supply any sample data so I'm guessing your data set 1 is in decimal hours for which I added a column.


    <colgroup><col style="width:...
  23. Replies
    3
    Views
    175

    Re: Date ranges in excel

    You could add a column to data set 1 to see if the date was "in London" then do a total of Billable and Non-Billable.


    <colgroup><col style="width:...
  24. Replies
    9
    Views
    289

    Re: conditional formatting help

    An example of your data would help but does this work? Row 7 gets highlighted.


    =AND($A2="Dog",$B2="Cat",$C2 > 33)



    <tbody>

    A
  25. Replies
    2
    Views
    115

    Re: Getting #VALUE when using IF(OR())

    I'm not sure why you're referencing B2 but does this do what you want?
    =IF(ISNUMBER($BP$2),BP2,IF(ISNUMBER($BP$3),BP3,""))
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4