Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    133

    Re: Filtered dataset / sort / hidden columns

    Thanks
  2. Replies
    2
    Views
    133

    Filtered dataset / sort / hidden columns

    If you a have sheet that is filtered, and hide columns, then sort (via any viewable column), does the hidden columns also sort?

    I have a fairly sizable file (12k rows, 37 cols; several columns...
  3. Replies
    10
    Views
    412

    Re: hlookup and offset

    Thanks Peter! That works perfectly! :beerchug: Thanks for the volatile link as well, I'm saving that :cool:
  4. Replies
    10
    Views
    412

    Re: hlookup and offset

    Thanks, I'll try that
  5. Replies
    10
    Views
    412

    Re: hlookup and offset

    Thanks, but nothing seems to work.

    =OFFSET(HLOOKUP(9.99999999999999E+307,B3:Y3,1),-2,-1) this is essentially what I'm after, but :banghead::banghead: .....is it scotch-thirty yet?
  6. Replies
    10
    Views
    412

    Re: hlookup and offset

    Trying something different (after watchin a MrExcel video about vlookup and offset), but now I get a value! error

    =OFFSET(B4,0,HLOOKUP(9.99999999999999E+307,C4:Z4,1),-2,-1)
  7. Replies
    10
    Views
    412

    Re: hlookup and offset

    I tried that, it gives me a #REF ! error
  8. Replies
    10
    Views
    412

    hlookup and offset

    I'm trying to combine hlookup() and offset() to find the last value in a row, then go up 2 rows and left 1 cell. Each works independently, but when I try to combine them, errors occur.
    ...
  9. excelisfun array multiple lookup in one cell

    :banghead::banghead::banghead:

    I came across an excelisfun video a while ago in which a lookup was used that showed all values in one cell. VERY similar to the textjoin(), but it worked in 2010....
  10. Replies
    3
    Views
    166

    Re: 'Message' using a lookup formula

    Awesome! Thanks, works perfectly.
  11. Replies
    3
    Views
    166

    'Message' using a lookup formula

    Is there a way to have a formula do:

    if any cell F3:F23 is less than -.25 or more than .1 "explain"?

    I have a conditional formula =AND($F11<>-1,OR($F11<-0.25,$F11>0.1)) that works great but I'd...
  12. Replies
    6
    Views
    192

    Re: offset and index/match

    :banghead: the cell references are not the the same. I missed a "$" It's working great!! Thanks :beerchug:

    ...
  13. Replies
    6
    Views
    192

    Re: offset and index/match

    Even more odd.... I copied the formula further down and populate and and some dont.
  14. Replies
    6
    Views
    192

    Re: offset and index/match

    Thanks! That works in the first cell on sheet 1, but when I copy down, the cells are "blank." Not sure why, the cell references look correct.
  15. Replies
    6
    Views
    192

    offset and index/match

    I've found a things, but I can't piece this together. From tab 1, I need to find and item on tab 2, move 1 cell left, and up to the next cell with data.

    First Tab: (the small blue info is what I...
  16. Thread: By-line totals

    by dmj120
    Replies
    11
    Views
    459

    Re: By-line totals

    That did the trick!! Thanks!!!!!! :beerchug: :pray: :pray:
  17. Thread: By-line totals

    by dmj120
    Replies
    11
    Views
    459

    Re: By-line totals

    Yes, the per diem would be (and is) multiplied by the number of days on my spreadsheet. I was just typing out a simple version of it.

    Yes you are correct, I added the totals on the SUMMARY...
  18. Thread: By-line totals

    by dmj120
    Replies
    11
    Views
    459

    Re: By-line totals

    No, I'm using 2010
  19. Thread: By-line totals

    by dmj120
    Replies
    11
    Views
    459

    By-line totals

    I am trying to create a summary table of expenses for a massive project for 35 people (each assigned a "type"). My data set is:


    <tbody>
    Type

    Pay Rate

    Days
  20. Thread: date formula

    by dmj120
    Replies
    4
    Views
    181

    Re: date formula

    ops, read it wrong.

    Used datedif(start date,end date,"M")
    W
  21. Thread: date formula

    by dmj120
    Replies
    4
    Views
    181

    Re: date formula

    Try month()

    =month(a2) and copy down
  22. Replies
    5
    Views
    128

    Re: vlookup tab reference

    UGH :banghead: :banghead: Thanks! It does work, it was the first half of the formula -if(iserror()..) that was the problem. Thank you very much :beerchug:
  23. Replies
    5
    Views
    128

    Re: vlookup tab reference

    Thanks, I tried that before -and again in case I messed it up before- and it when hitting enter, a window pops up for me to click a file. I even tried cntl+****+enter see if adding {} would...
  24. Replies
    5
    Views
    128

    vlookup tab reference

    I have a workbook that has a summary tab, which "looks up" the info on several other 'facility tabs.' I used Lookup() and index() to make it a nice expandable workbook -just have to add tabs- and...
  25. Re: date/time calc --- date and times are in diffeent columns

    Sweet, thanks!!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4