Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: Produce a new list based on values in a range

    Thank you Fluff you're a genius! You've helped me again. Many, many thanks. Bj
  2. Produce a new list based on values in a range

    Hello,

    I have a very long list of products and values and I need to produce another list that list products by a range of quantity. My list looks similar to this:-

    ...
  3. Replies
    4
    Views
    158

    Re: Qty required to get to the next 100th

    Thank you so much. We all need more Fluff! brilliant!
  4. Replies
    4
    Views
    158

    Qty required to get to the next 100th

    Hello, I have a a big list of varying numbers and I need to calculate how many are needed to reach the next 100. eg

    145 result needed would be 55 (next 100 is 200)
    23 result needed would be 77...
  5. Re: Count filled cells below a specific heading

    Hi, yes I know that but I need to summarise all of the counts against the column headings from all my workbooks in a separate sheet, so needed to use the column headings. Is this possible?
  6. Count filled cells below a specific heading

    Hello, I have a file with multiple worksheets and I need to summarise the number of filled cells below each specific column heading in a different spreadsheet. Is there a formula to do this?

    eg...
  7. Replies
    9
    Views
    226

    Re: Count Incidents by date

    Thanks everone all sorted now.
  8. Replies
    9
    Views
    226

    Re: Count Incidents by date

    Yes, was trying with the multiple criteria but kept getting "two few arguments". My formula didn't work. I used an ampersand to split the two arguments which was probably wrong. any suggestions?
  9. Replies
    9
    Views
    226

    Re: Count Incidents by date

    Thanks for this but I tried this and my date column kept appearing in the pivot table as year and quarters not the actual date. This was the reason I was then trying to use the countifs. (the file...
  10. Replies
    9
    Views
    226

    Count Incidents by date

    Hi, I have a spreadsheets that contains a list of incidents by date. The date therefore appears numerous times (column A) and various codes appear in the 2nd column (column B). How do I count the...
  11. Replies
    2
    Views
    148

    Re: If/and statement

    Hello Steve, Thanks for this but my value I'm trying to get this formula on is in one cell only so this doesn't work in my instance. thanks B
  12. Replies
    2
    Views
    148

    If/and statement

    Hello can anyone help with a if/and statement in Excel? I'm looking for a formula to indicate whether the resulting value is >= plus or minus 10%. I can complete a formula for one of the values but...
  13. Thread: If statement

    by bj6264
    Replies
    3
    Views
    251

    Re: If statement

    thank you, you're a star! :cool:
  14. Thread: If statement

    by bj6264
    Replies
    3
    Views
    251

    If statement

    Hi, I have a list of dates which I've converted to showing only the month using =Text(a2,"mmmm") but some of the cells in the column are blanks and I've tried to use this formula
    ...
  15. Replies
    2
    Views
    175

    Re: ctrl+end in Excel

    Hi Kev, I had tried this but it didn't work but it worked this time! many thanks. B:)
  16. Replies
    2
    Views
    175

    ctrl+end in Excel

    Hello, can someone help please? If I use ctrl+ end on one of my spreadsheets, the cursor goes all the way to the bottom ie row 1048576 and to the last column I have used. I only have about 50 rows...
  17. Replies
    4
    Views
    192

    Re: Calculation using the last value in a cell

    Stunning! Worked perfectly. Thank you! :)
  18. Replies
    4
    Views
    192

    Re: Calculation using the last value in a cell

    Hello, unfortunately not or I could use the =right function.
  19. Replies
    4
    Views
    192

    Calculation using the last value in a cell

    Hello, can someone help please. I have a list of prices but some cells contain multiple values where the value has changed. I need a formula that will use the last value in a cell. Example below. ...
  20. Re: Macro for creating new workbooks from 1 workbook with multiple sheet

    Many many thanks!:)
  21. Re: Macro for creating new workbooks from 1 workbook with multiple sheet

    Thanks for your reply but I'm a real novice to VBA and your answers are way above my level. I think this may be a manual task for me.:eeek:
  22. Re: Macro for creating new workbooks from 1 workbook with multiple sheet

    Thanks but this isn't quite what I want. I want to make all worksheets in 1 exisiting workbook into new workbooks - nothing to do with months.
  23. Macro for creating new workbooks from 1 workbook with multiple sheet

    Hello

    Can anyone help with a simple macro for creating new workbooks from 1 workbook that has about 50 sheets?

    Thanks
  24. Re: Help with formula to count up to a blank cell

    Pete

    Many thanks again, will do as you suggested.
    :)
  25. Re: Help with formula to count up to a blank cell

    Brilliant, many many thanks!
Results 1 to 25 of 45
Page 1 of 2 1 2