# Search:

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

Page 1 of 2 1

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

by bj6264
Replies
3
Views
84

### 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. ## Thread: Produce a new list based on values in a range

by bj6264
Replies
3
Views
84

### 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. ## Thread: Qty required to get to the next 100th

by bj6264
Replies
4
Views
158

### Re: Qty required to get to the next 100th

Thank you so much. We all need more Fluff! brilliant!
4. ## Thread: Qty required to get to the next 100th

by bj6264
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...

by bj6264
Replies
2
Views
261

### 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?

by bj6264
Replies
2
Views
261

### 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. ## Thread: Count Incidents by date

by bj6264
Replies
9
Views
226

### Re: Count Incidents by date

Thanks everone all sorted now.
8. ## Thread: Count Incidents by date

by bj6264
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. ## Thread: Count Incidents by date

by bj6264
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. ## Thread: Count Incidents by date

by bj6264
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...

by bj6264
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

by bj6264
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...

by bj6264
Replies
3
Views
251

### Re: If statement

thank you, you're a star! :cool:

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. ## Thread: ctrl+end in Excel

by bj6264
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. ## Thread: ctrl+end in Excel

by bj6264
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. ## Thread: Calculation using the last value in a cell

by bj6264
Replies
4
Views
192

### Re: Calculation using the last value in a cell

Stunning! Worked perfectly. Thank you! :)
18. ## Thread: Calculation using the last value in a cell

by bj6264
Replies
4
Views
192

### Re: Calculation using the last value in a cell

Hello, unfortunately not or I could use the =right function.
19. ## Thread: Calculation using the last value in a cell

by bj6264
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. ## Thread: Macro for creating new workbooks from 1 workbook with multiple sheet

by bj6264
Replies
8
Views
435

### Re: Macro for creating new workbooks from 1 workbook with multiple sheet

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

by bj6264
Replies
8
Views
435

### 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. ## Thread: Macro for creating new workbooks from 1 workbook with multiple sheet

by bj6264
Replies
8
Views
435

### 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. ## Thread: Macro for creating new workbooks from 1 workbook with multiple sheet

by bj6264
Replies
8
Views
435

### 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. ## Thread: Help with formula to count up to a blank cell

by bj6264
Replies
4
Views
254

### Re: Help with formula to count up to a blank cell

Pete

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

by bj6264
Replies
4
Views
254

### 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