Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    6
    Views
    258

    So it seems, since that works perfectly! Many...

    So it seems, since that works perfectly! Many thanks, RG! I have to admit I just took the examples on the page you sent me to at face value, and the one that said it would count all unique text and...
  2. Replies
    6
    Views
    258

    Thanks, Paul and RG. I know the dates are just...

    Thanks, Paul and RG. I know the dates are just straight dates since I enter them, though.

    I'm fairly certain this is what I want:

    =SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""),...
  3. Replies
    6
    Views
    258

    Count unique values?

    Is there a way to use the Count function to count unique values in a range? Only I have a column of dates that will occasionally have duplicates, and a cell that counts the entries in that column,...
  4. Okay, thanks again RG and Zeddy - I've got...

    Okay, thanks again RG and Zeddy - I've got something usable now that's *almost* exactly what I wanted! I discovered that I don't need to add an extra column to the results table, if I get the list...
  5. Hi RG, thanks for this but I must admit I was...

    Hi RG, thanks for this but I must admit I was hoping for something that didn't include the year - and my layout is per the attached, sorry should have done that in the first place. I can live with...
  6. Need to create summary of data in two-column table

    Hi folks, my XL (2010) is a bit rusty so I would appreciate a bit of a boost in the right direction, please!

    I have a list of a year's worth of invoices with columns for the date and the number of...
  7. Replies
    2
    Views
    2,358

    Have logo - how do I find its name?

    I don't know that this is the right place for this, but I can't find a better one - feel free to move it if you know of one! Anyway, can any one tell me how to find out the name of a company for...
  8. Replies
    7
    Views
    2,105

    Thank you, Zeddy, that's great!

    Thank you, Zeddy, that's great!
  9. Replies
    7
    Views
    2,105

    Hi Zeddy, slight misunderstanding here - I need...

    Hi Zeddy, slight misunderstanding here - I need to be able to select a block of cells, several columns by several rows - which will not necessarily be the current region as we have columns of...
  10. Replies
    7
    Views
    2,105

    Thank you, Zeddy, I think that will do what I...

    Thank you, Zeddy, I think that will do what I want! One question, though - how do you "put the cellpointer in the column you want sorted"? I did it by starting the selection in that column (which...
  11. Replies
    7
    Views
    2,105

    I keep trying to edit the above post to make my...

    I keep trying to edit the above post to make my request clearer, but it won't accept any changes, so herewith the altered version separately: "Is there any way to write a macro that would tell XL to...
  12. Replies
    7
    Views
    2,105

    How to do a last column sort?

    Is there any way to write a macro that would tell XL to just sort by the last column of the current selection, largest to smallest?I do get so fed up with having to set up the sort, telling it which...
  13. Replies
    12
    Views
    4,830

    Well, I did say it seemed strange, and even...

    Well, I did say it seemed strange, and even counter-intuitive - but it worked for a similar problem for us.

    Try it. If it doesn't work, re-check it.

    What have you got to lose?!
  14. Replies
    12
    Views
    4,830

    I don't know if this will help, but we had a...

    I don't know if this will help, but we had a similar problem in O2007 recently (the ends of prints were being lost), and it turned out that it was fixed by going to Office > Word Options > Advanced ...
  15. Replies
    17
    Views
    1,431

    Assuming that a cell name is text, wouldn't the...

    Assuming that a cell name is text, wouldn't the error problem be resolved if you asked

    If ActiveCell.Name = "" then ...
    or
    If ActiveCell.Name <> "" then ... (for the double negative route)
    ...
  16. Well, all I can say is, when I opened your...

    Well, all I can say is, when I opened your example doc, right-clicked on the 'cropped' picture, chose 'size' and reduced the percentage, the rest of the picture began to appear.
  17. The chart is not being cropped, it's being...

    The chart is not being cropped, it's being resized to match the height of the space in one instance and the width in the other; and where it's the height, the part of the chart that won't fit on the...
  18. http://lounge.windowssecrets.com/public/style_emot...

    http://lounge.windowssecrets.com/public/style_emoticons/default/cheers.gif
  19. Thanks, Gary, that was the switch I was looking...

    Thanks, Gary, that was the switch I was looking for - I just didn't know what it was called!

    http://lounge.windowssecrets.com/public/style_emoticons/default/cheers.gif
  20. Hi Hougs On your own profile, go to Settings,...

    Hi Hougs

    On your own profile, go to Settings, UNcheck 'disable private messages' and Save. The link will then reappear on people's profiles.
  21. Hi Hougs If you click on JScher2000's name...

    Hi Hougs

    If you click on JScher2000's name against any of his posts, it will take you to his profile. The 'send a message' link is below the picture there.
  22. We're used to having a lot of styles around - the...

    We're used to having a lot of styles around - the default setup here is for a couple of dozen customised styles we use to appear at the top of the list (organised by the old-fashioned method of...
  23. Replies
    4
    Views
    1,521

    Interesting - I can't see why on earth you should...

    Interesting - I can't see why on earth you should need to be signed in before you can print.

    On the other hand, I can't see any reason *not* to sign in, if you want to do something here that...
  24. Replies
    2
    Views
    612

    LOL - thanks, Jscher!

    LOL - thanks, Jscher!
  25. Replies
    2
    Views
    1,396

    Well, I use 2007 and show two tabs from the same...

    Well, I use 2007 and show two tabs from the same spreadsheet side-by-side fairly frequently - I use New Window, Arrange All, Vertical. Can you not spread the Excel window across both screens and...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4