Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds; generated 54 minute(s) ago.

  1. Replies
    13
    Views
    919

    Re: Inserting Rows Automatically... ?

    Is there no fix or work-around for this?



    Awesome! Thank you so much!

    But there's another problem now lol - this error message keeps coming up ... "Exceeded maximum execution time"

    Is...
  2. Replies
    13
    Views
    919

    Re: Inserting Rows Automatically... ?

    Awesome! Thank you so much!

    But there's another problem now lol - this error message keeps coming up ... "Exceeded maximum execution time"

    Is there any way to increase the execution time or...
  3. Replies
    13
    Views
    919

    Re: Inserting Rows Automatically... ?

    I'll try - hopefully screenshots will make it clearer... also, I said 25 rows in total before - sorry, it should be 26!



    This is the list I receive - there are about 100 "groups" of between 1...
  4. Replies
    13
    Views
    919

    Re: Inserting Rows Automatically... ?

    You are Awesome bro!

    Is this how I should proceed...
    1) I copy your code in to Google Sheets menu - Tools>Script Editor... which opens a new sheet
    2) Then go back to my working sheet - and...
  5. Replies
    13
    Views
    919

    Re: Inserting Rows Automatically... ?

    Could this code be amended to work with another similar sheet?

    It has columns A to Q - with column C being differing numbers from 1 to 25 containing a set of data...


    <tbody>
    A
    B
    C
    D
  6. Replies
    4
    Views
    182

    Re: VLOOKUP Not Showing Result ?

    Thank you! I'd have never thought of using SUM or MAX - even though it's so obvious lol!

    Is there a specific reason why VLOOKUP doesn't play well with numbers?
  7. Replies
    4
    Views
    182

    VLOOKUP Not Showing Result ?

    It's a pretty simple function - just look down the column range and display the cell that is not blank...

    =VLOOKUP("?*",A2:A12,1,0)

    It works when there is text in the cell - but gives an error...
  8. Replies
    13
    Views
    919

    Re: Inserting Rows Automatically... ?

    Dangit! I was hoping it wouldn't involve code as I've never used this method before! How do I proceed?

    I receive the list from someone using Google Sheets - can I get Sheets to perform this action...
  9. Replies
    13
    Views
    919

    Inserting Rows Automatically... ?

    I'm working with a long list which is a bunch of names in one column - they are in teams of a maximum of 5, but usually less so I need to create blanks rows to keep things in order:

    Column A/B is...
  10. Counting The Number Of Non-Duplicate Cells ??

    What is the easiest way to count cells with the same value, across columns?


    <tbody>
    A
    B
    C
    D
    E
    F
  11. Re: COUNTIF question - counting cells which contain a specific letter...

    Yup!

    I know, it's a very strange request!
  12. Re: COUNTIF question - counting cells which contain a specific letter...

    Thanks for the reply!

    Is there a way to do it, without using an array formula?
  13. Re: COUNTIF question - counting cells which contain a specific letter...

    Sorry for causing so much confusion! I think I've found the problem...

    Yes that formula does work - but I thought it didn't, because it also counts other characters like - / etc... dangit!

    Is...
  14. Re: COUNTIF question - counting cells which contain a specific letter...

    Still not working!

    I need the value to be at the top in cell A1... and to count the cells which contain non-numerical letters.

    It is formatted in plain text, which I think is the cause of the...
  15. Re: COUNTIF question - counting cells which contain a specific letter...

    Doesn't work either - is this impossible to do?
  16. Re: COUNTIF question - counting cells which contain a specific letter...

    Tried but doesn't seem to work... thank you anyway!
  17. Re: COUNTIF question - counting cells which contain a specific letter...

    Yes, the formatting is Text... dangit!

    Is it still possible to do somehow?
  18. Re: COUNTIF question - counting cells which contain a specific letter...

    Yup!


    <tbody>
    5
  19. Re: COUNTIF question - counting cells which contain a specific letter...

    I tried that - but forgot the "" lol... thank you!

    Is there a way to count cells which contain a number of different letters, or even any kind of alphabetical character?
  20. COUNTIF question - counting cells which contain a specific letter...

    Is there a way to use the COUNTIF function to count cells if they contain a single letter - for example below, when a cell has the letter A, the count would be 3 in the top row


    <tbody>
    3
  21. Replies
    13
    Views
    966

    Re: SUBSTITUTE a Blank space...

    I removed the \ from the TEXT function and it seems to have solved the problem!

    What does the \ do within the TEXT function? (Better check with you, in case it breaks something else!)
    ...
  22. Replies
    13
    Views
    966

    Re: SUBSTITUTE a Blank space...

    Thanks for the reply!

    I've checked that the formula is text, and it's still not working...

    This is the formula customised for my spreadsheet - is there a mistake in it?
    ...
  23. Replies
    13
    Views
    966

    Re: SUBSTITUTE a Blank space...

    Sorry for bothering you again!

    The formula works great - except when the cell contains a number that begins with zero...

    So 50 becomes A50 - but 05 stays the same, instead of becoming A05

    Is...
  24. Replies
    2
    Views
    132

    Limiting the SPLIT function...

    <tbody>
    ABC - DEF - GHI - JKL - MNO
    ABC
    DEF
    GHI
    JKL
    MNO
  25. Replies
    16
    Views
    352

    Re: Searching down column and displaying value?

    Awesome!
Results 1 to 25 of 58
Page 1 of 3 1 2 3