Search:

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

Page 1 of 6 1

1. Thread: Non Case Sensitive Dictionary

by sheetspread
Replies
11
Views
217

Re: Non Case Sensitive Dictionary

Set them equal with a ucase or lcase.
2. Thread: Sum 2-dimension array

by sheetspread
Replies
3
Views
164

Re: Sum 2-dimension array

=SUMIFS(Sheet1!\$D\$2:\$D\$7,Sheet1!\$B\$2:\$B\$7,Sheet2!C2,Sheet1!\$E\$2:\$E\$7,">="&TODAY())

considers the expire date.

What do you want the macro to do? Put the formula in each cell or something else?
3. Thread: Sum 2-dimension array

by sheetspread
Replies
3
Views
164

Re: Sum 2-dimension array

=IF(E2>SUMIF(Sheet1!\$B\$2:\$B\$7,Sheet2!C2,Sheet1!\$D\$2:\$D\$7),"Not Enough","Enough")
4. Thread: Formula to grab the first non-zero value in a row of data, and then every value after that.

by sheetspread
Replies
4
Views
126

:beerchug:
5. Thread: What happens if i keep Application.ScreenUpdating = False ?

by sheetspread
Replies
6
Views
265

Re: What happens if i keep Application.ScreenUpdating = False ?

If it's just one sub then start with false and return to true just before the end.
6. Thread: What happens if i keep Application.ScreenUpdating = False ?

by sheetspread
Replies
6
Views
265

Re: What happens if i keep Application.ScreenUpdating = False ?

Did you time it?

https://www.mrexcel.com/forum/excel-questions/628173-vba-test-macro-speed.html

Even inefficient code may not appear slow unless there's lots of data/intense calculations
7. Thread: Formula problem referencing cells with #N/A

by sheetspread
Replies
2
Views
149

Re: Formula problem referencing cells with #N/A

Try:

=IF(COUNTIF(H2:I2,"Apples")>0,"Red",B2)
8. Thread: Return multiple variables from a Function

by sheetspread
Replies
3
Views
145

Re: Return multiple variables from a Function

Check these out:

https://www.mrexcel.com/forum/excel-questions/842465-excel-vba-create-jagged-two-dimensional-array.html
...
9. Thread: AverageIF issue

by sheetspread
Replies
1
Views
77

Re: AverageIF issue

Is :80 the same as 1:20? Are the cells highlighted in blue below the ones you're trying to average?

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color:...
10. Thread: Formula to grab the first non-zero value in a row of data, and then every value after that.

by sheetspread
Replies
4
Views
126

Re: Formula to grab the first non-zero value in a row of data, and then every value after that.

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
11. Thread: Help with formula please.

by sheetspread
Replies
17
Views
415

Re: Help with formula please.

Type alt-f11, paste the code, and run (via the play button or F5 key)
12. Thread: Help with formula please.

by sheetspread
Replies
17
Views
415

Re: Help with formula please.

Be sure everything matches exactly. There are spaces between your cells so simply dragging over will distort many of the references.
13. Thread: Help with formula please.

by sheetspread
Replies
17
Views
415

Re: Help with formula please.

If you don't feel like typing or pasting the formulas you can run this code on a copy of your sheet:

Sub formulapaste()
Range("D5").Value =...
14. Thread: Help with formula please.

by sheetspread
Replies
17
Views
415

Re: Help with formula please.

Here are all the formulas:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
15. Thread: Help with formula please.

by sheetspread
Replies
17
Views
415

Re: Help with formula please.

Then something like:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
16. Thread: Too many pages

by sheetspread
Replies
2
Views
123

Re: Too many pages

Go into page break view and adjust, you probably have extra vertical/horizontal lines all over the place.
17. Thread: To Separate the men from the women

by sheetspread
Replies
4
Views
193

Re: To Separate the men from the women

Something like:

https://i.imgur.com/iihItqh.png

(2 tables)
18. Thread: To Separate the men from the women

by sheetspread
Replies
4
Views
193

Re: To Separate the men from the women

The pivot table does this
19. Thread: Find the first cell in a Column with a specific Date

by sheetspread
Replies
1
Views
97

Re: Find the first cell in a Column with a specific Date

Use the DATEVALUE function
20. Thread: Working backwards to find initial starting value

by sheetspread
Replies
2
Views
163

Re: Working backwards to find initial starting value

This?

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
21. Thread: Dynamic criteria for SUMIF or dynamic getpivotdata

by sheetspread
Replies
7
Views
309

Re: Dynamic criteria for SUMIF or dynamic getpivotdata

Are you able to scale it down at all? This does look like an interesting problem.
22. Thread: VBA to sumproduct & loop...I think

by sheetspread
Replies
6
Views
352

Re: VBA to sumproduct & loop...I think

Better formula:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
23. Thread: VBA to sumproduct & loop...I think

by sheetspread
Replies
6
Views
352

Re: VBA to sumproduct & loop...I think

It's easier if your bill of materials is in single column format rather than a matrix. With Ingredient B as zero for products 1 and 2:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all"...
24. Thread: VBA to sumproduct & loop...I think

by sheetspread
Replies
6
Views
352

Re: VBA to sumproduct & loop...I think

I would just add a filter to hide the zeroes, a formula will be bulky and slow.
25. Thread: VBA to sumproduct & loop...I think

by sheetspread
Replies
6
Views
352

Re: VBA to sumproduct & loop...I think

This?

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
Results 1 to 25 of 150
Page 1 of 6 1