Excel MAXA formular question.?

Say for example in Column A I have initials of various sales person (TL, GL, SE) and in Column B I have the date of the last order that came in under their name. I am looking for a formular that doe's a MAXA on the date column but only on the Row's where TL appears.

Any ideas

Many thanks
Oscar100

This is easy with an array formula:

=MAXA(IF(A1:A100="TL", B1:B100, 0))

Input this using Ctrl-Shift-Enter rather than just Enter.

It will look in A1:A100. If it finds "TL" in a cell, it will consider what's in B on the same row for the MAXA function.

I hope that helps, but add more details or e-mail if you need more info.
Best of luck.
.

try using an IF formula.

You could use an Excel query (advanced filter) to create three pairs of columns in an unused section of the worksheet, each for TL, GL and SE exclusively, then use your MAXA on each of the separated columns.

Tags

　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook

Related information

Mouse pointer returns to default???

Are you clicking the "Apply" button Before OK?

...

How do I make a Vista live CD?

Vista has a feature within its Control Panel that you can make a recovery disk with.

...

What's a really good, free DivX to DVD burning software I can use?

ConvertxtoDVD. I think it only has a 30 day trial, but I've been using for 2 weeks, no water marks no limitations. Burns and converts like a champ too.

...

Which is the best to download Music and Movies?

There are quite a number of site able to help you to do so.. like limewire and bearshare, which is free but it is illegal and lot of virus on the song downloaded, which will crash your system easil...

Why can't I see pictures in the new Microsoft Word?

Good question. It's hard to find the answer, even in WORD help. It is probable that Picture Placeholders have been enabled. Click the OFFICE BUTTON in upper left corner. Choose WORD OPTIONS...

What is the best ISP to use with windows mail in Vista?

It really shouldn't matter which ISP you use. All of them offer largely the same in regards to POP email accounts. You might want to consider Mozilla Thunderbird instead of Windows Mail though...

Why do so many people slag off Vista ?

There is a very simple answer to your question that everyone above ^ seems to not want to acknowledge... Vista is a great operating system, that works smoothly, effortlessly and stabily with NEW...

How do i turn bitcomet to being my default downloader?

BitComet is for .torrent files only!

...