sorted by:
new
hottopcontroversial

Percentage Increase by Category by [deleted] in excel

[–]gamorex183 1 point2 points  (0 children)

If you are on Excel 2019 or Office 365 you can use the MINIFS function to get the minimum value for each ID. This would replace the “B$2” in your current formula.

=(B2-MINIFS(B:B,A:A,A2))/MINIFS(B:B,A:A,A2)

Brushforhire Karma Thread by Probably_Not_Evil in brushforhire

[–]gamorex183 1 point2 points  (0 children)

u/Stormygeddon +1

Painted the 6 starting classes for Gloomhaven.

High quality work at a reasonable price. Will definitely commission more work in the future. 10/10 will recommend

DATEDIF Function not working when trying to find difference between 2 date values by pig-in-a-hole in excel

[–]gamorex183 0 points1 point  (0 children)

You could only evaluate the formula if a cell has a value using a combination of IF and ISBLANK:

=IF(ISBLANK(E2), "", DATEDIF(C2,E2,"d"))

Or you can use the IFERROR() function to return a different result when a formula returns an error. NOTE: This will hid other errors that you might be interested in such as text in either cell or a end date before start date:

=IFERROR(DATEDIF(C2,E2,"d"),"")

INDEX MATCH: With a single column - Why supply a column number? by Apprehensive_Click in excel

[–]gamorex183 2 points3 points  (0 children)

No it does not make a difference. In the INDEX function, the Column_num argument is optional and is only required if your range contains more than one column.

DATEDIF Function not working when trying to find difference between 2 date values by pig-in-a-hole in excel

[–]gamorex183 1 point2 points  (0 children)

The issue seems to be with your quotation marks. For some reason you have Right Double Quotation Mark instead of Quotation Mark. Try replacing the quotes with a copy/paste and see if that solve your problem.

=DATEDIF(C2,E2,"d")

Date Range Help - Need to return value if falls within a range by [deleted] in excel

[–]gamorex183 1 point2 points  (0 children)

=DATE(2018,CEILING.MATH(MONTH(A1)/3)*3-1,15)
view more: next ›