microsoft.public.excel.misc | Forum profile

  You posted the same question yesterday and I responded If this post helps click Yes --------------- Jacob Skaria "Al" wrote: > Yes, I am new to macros, so I will experiment as per your suggestion...thank > you very much! > > What did you mean by "What happened to your previous post.....?" > > > > "Jacob Skaria" wrote:...

  Try this =IF(COUNTA(D1:I1)=0,"X","") Mike "Jim" wrote: > Hello, > > I have about 5k lines of data. Columns A, B and C all have data. D, E, F, > G, H and I may or may not have data. In K I would like to have a formula > that would read D, E, F, G, H and I and if they are all blank I would like > for K to return a X. > >...

  As Mike H and Jacob have mentioned, there are several ways to overcome this. IMO, it is an unneeded function as you can simply do: =SUMIF(A:A,"Condition",B:B)/COUNTIF(A:A,"Condition") Note that this is not an array formula. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "lisab" wrote: > I'm trying to average the values in...

  Very nice -- Gary''s Student - gsnu200908 "Jacob Skaria" wrote: > For cell address..(normal entered) > =ADDRESS(SUMPRODUCT(MATCH("",A1:A100&"",0)),COLUMN(A1:A100)) > > If this post helps click Yes > --------------- > Jacob Skaria > > > "Jacob Skaria" wrote: > >...

  What do you mean by "scaled down to nothing"? Right-click cell and Insert Comment. Right-click on border of Comment and Format Comment. Select Colors and Lines>Color>Fill Effects>Picture. Exactly the same as 2003. Gord Dibben MS Excel MVP On Wed, 4 Nov 2009 09:03:01 -0800, notahacker <notahacker@discussions.microsoft.com> wrote: >I have seen how to add a pop up picture as...

  Well, sorry about the triple post - damned HTML side of this mess kept telling me that it wasn't posting my response. "Jared" <Jared@discussions.microsoft.com> wrote in message news:E965ACF7-6955-4B76-B25F-09C0438E6D91@microsoft.com... > So, here is the basic problem - I have one spreadsheet that has 100's of > codes, and information below each code. I have another spreadsheet...

  Just paste this formula in B2 cell =IF(--TRIM(LEN(G2))=5,"STAFF TYPE2",IF(--TRIM(LEN(G2))=7,"STAFF TYPE1","")) Now copy the B2 cell formula and apply it for the remaining cells. Change the cell reference G2 to your desired cell if required. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "GaiGauci" wrote: > Hi...

  Good morning Sir, A B C D E F Orange Orange Banana Banana Tomato Tomato Other Fleet Other Fleet Other Fleet 1 2 33 1 8 1 4 5 6 5 4 9 7 8 9 8 35 5 10 11 12 9 66 4 the formula is to find in the table the sum of Banana fleet please help Regards "Jacob Skaria" wrote: > Interesting. Try the below test in a new sheet. > > Col A Col B Col C > other fleet other > 1 2 3 > 4 5 6...

  What happens when you select the Files in Windows Explorer, and then r-click on them and pick Convert to PDF? Phil J W wrote: > Can this be done? I have about 500 store specific excel files, with 2 sheets > each. I'd like a quick way to PDF all of them, not as one big file, but as > individule PDFs. Here at the office we are using Office 2007 and Adobe > Acrobat 9 Pro...thank you. .  

  To "flatten" a worksheet...removing all the formulas but keeping the data: 1) Select the sheet 2) Press CTRL-A to select ALL the data on the sheet. You might have to press CTRL-A several time to get it all 3) Press CTRL-C to copy everything 4) Click on Edit > PasteSpecial > Values Now the sheet is flattened, no formulas are left on the sheet. -- "Actually, I *am* a rocket...