Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    Yes I agree with you and for the most part youre correct. But if I ask for vlookup countless times upon answers that have nothing to do with it, something's not right here, unless vlookup is...
  2. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    What kind of question is that?



    An assignment??



    Hi markmzz,
  3. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    Seriously I dont know what youre talking about. I really dont. Youre saying things which go over my head. If you dont know the answer thats fine. I'll wait for someone who does.
  4. Replies
    8
    Views
    394

    Re: How to Show Standard Time in NOW Function?

    It was never explained relating to NOW.
  5. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    What do I "think" I have in E9? Theres nothing in E9. After I hit enter I get an error message. But nothing in E9.
  6. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    E9? I dont have anything in E9. I just want to make this possible with vlookup not match index.
  7. Replies
    8
    Views
    394

    Re: How to Show Standard Time in NOW Function?

    Ahhh.. thank you so much.. its the answer I was looking for especially the part about custom formatting.. thank u again!
  8. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    I'm confused. I needed vlookup not match index.
  9. Re: Can't Find Summed Value of 2 Largest Numbers in Vlookup

    DO NOT hijack teh thread! If you need help with your problem create a thread.
  10. Replies
    8
    Views
    394

    Re: How to Show Standard Time in NOW Function?

    I'm confused. How would I enter this into =NOW()?
  11. Replies
    1
    Views
    234

    Question for Accountants!

    Hi guys,

    This is a question for all you accountants. I'd like to know what do you use vlookup on or other function specifically. And please provide examples... not with excel but in your words....
  12. Replies
    8
    Views
    394

    How to Show Standard Time in NOW Function?

    How do I use =NOW() to give me the current date (of course), but standard time, not military time. For ex, I want the time after the date to show as 4:00 not 1600.
  13. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    And where is vlookup in your formula?
  14. Re: How Do I Find Summed Values of 2 Largest Numbers in Vlookup

    Oh god...
  15. Re: How Do I Show # of Days Before Today's Date?

    No, no thats not exactly what I mean. Its best that you look at the sheet itself. The link is posted below. Go to the Invoice Data tab. Then click any date in the 'Date' tab. When you click in one of...
  16. How Do I Show # of Days Before Today's Date?

    In one column in my sheet it says '=TODAY()-31' when I click in it. The date happens to be 31 days before today's date. How do I format a column of past dates like this so that when I click in the...
  17. Re: Can't Find Summed Value of 2 Largest Numbers in Vlookup

    Any way to use LARGE in VLOOKUP?
  18. Re: Can't Find Summed Value of 2 Largest Numbers in Vlookup

    Come on dude.. this isnt high school stuff I'm asking. Get serious
  19. Re: Can't Find Summed Value of 2 Largest Numbers in Vlookup

    Thats not it. I need to use vlookup.
  20. Can't Find Summed Value of 2 Largest Numbers in Vlookup

    I'm trying to use vlookup to lookup a value that sums up the 2 largest numbers in columns B,C and D. I tried these 2 formulas on my own but thet dont work. I also tried using them as array functions....
  21. Replies
    15
    Views
    676

    re: DATE Format Gives Weird Result

    Hey dude.. it worked! It didnt work before cuz I was selecting the default value in 'date'. Thanks a million !!!!

    Appreciate all the help from the other fellows!!! Thanks guys!
  22. Replies
    15
    Views
    676

    re: DATE Format Gives Weird Result

    I swear to god I tried it and it doesnt work. Could you try it to see if it works on your end?
  23. Replies
    15
    Views
    676

    re: DATE Format Gives Weird Result

    Ahh I see.. I didnt know periods were included as characters in the MID formula. Thanks.



    That doesnt work. Couild you explain why it doesnt work>?
  24. Replies
    15
    Views
    676

    DATE Format Gives Weird Result

    Hi guys,

    I'm using a DATE function to format a date to MM/DD/YEAR. I want to format 31.3.14 to 3/31/2014. I used this formula:
    =DATE(2000+RIGHT(C12,2),MID(C12,3,2),LEFT(C12,2))

    But it results...
  25. Replies
    2
    Views
    190

    Re: Strange Vlookup Behavior

    Makes sense now.. thanks!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4