# Search:

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

Page 1 of 6 1

1. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

### 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. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

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

What kind of question is that?

An assignment??

Hi markmzz,
3. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

### 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. ## Thread: How to Show Standard Time in NOW Function?

by bencar
Replies
8
Views
394

### Re: How to Show Standard Time in NOW Function?

It was never explained relating to NOW.
5. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

### 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. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

### 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. ## Thread: How to Show Standard Time in NOW Function?

by bencar
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. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

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

I'm confused. I needed vlookup not match index.

by bencar
Replies
36
Views
2,062

10. ## Thread: How to Show Standard Time in NOW Function?

by bencar
Replies
8
Views
394

### Re: How to Show Standard Time in NOW Function?

I'm confused. How would I enter this into =NOW()?
11. ## Thread: Question for Accountants!

by bencar
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. ## Thread: How to Show Standard Time in NOW Function?

by bencar
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. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

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

And where is vlookup in your formula?

by bencar
Replies
36
Views
2,062

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

by bencar
Replies
13
Views
684

### 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. ## Thread: How Do I Show # of Days Before Today's Date?

by bencar
Replies
13
Views
684

### 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. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

### Re: Can't Find Summed Value of 2 Largest Numbers in Vlookup

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

by bencar
Replies
36
Views
2,062

### 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. ## Thread: Can't Find Summed Value of 2 Largest Numbers in Vlookup

by bencar
Replies
36
Views
2,062

### Re: Can't Find Summed Value of 2 Largest Numbers in Vlookup

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

by bencar
Replies
36
Views
2,062

### 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. ## Thread: DATE Format Gives Weird Result

by bencar
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. ## Thread: DATE Format Gives Weird Result

by bencar
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. ## Thread: DATE Format Gives Weird Result

by bencar
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. ## Thread: DATE Format Gives Weird Result

by bencar
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. ## Thread: Strange Vlookup Behavior

by bencar
Replies
2
Views
190

### Re: Strange Vlookup Behavior

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