Search:

Type: Posts; User: Scott Huish; Keyword(s):

Page 1 of 6 1

1. Thread: Day or Arrival, Plus 2

by Scott Huish
Replies
4
Views
50

Re: Day or Arrival, Plus 2

Can you please provide a sample of what you need exactly?
2. Thread: Day or Arrival, Plus 2

by Scott Huish
Replies
4
Views
50

Re: Day or Arrival, Plus 2

Maybe I'm missing something but wouldn't that be:

=WORKDAY(C16,2,M16:M28)
3. Thread: convert M/D/YYYY to MM/DD/YYYY

by Scott Huish
Replies
9
Views
22,385

Re: convert M/D/YYYY to MM/DD/YYYY

Assuming that value was in A1, perhaps something like this:

=VLOOKUP(TEXT(A1,"mm/dd/yyyy"),A2:C100,2,0)

by Scott Huish
Replies
4
Views
66

Re: @MATCH Function?

Pretty sure, it's from Lotus 1-2-3.

You can in Lotus like fashion, enter @SUM(A1:A3) but it converts it to Excel format.
5. Thread: Formula for if time is same, earlier or later?

by Scott Huish
Replies
12
Views
311

Re: Formula for if time is same, earlier or later?

VBA does have a MOD function, however it only returns integer results, so would not be useful here.
6. Thread: Formula for if time is same, earlier or later?

by Scott Huish
Replies
12
Views
311

Re: Formula for if time is same, earlier or later?

If there are dates in the cells with the times, you could eliminate the nested IF like this:

=TEXT(MOD(S2,1)-MOD(R2,1),"""LATER"";""EARLIER"";""SAME""")

by Scott Huish
Replies
5
Views
31

Re: time format

You can put in 112:00
and format as [h]:mm
8. Thread: Univers and Channels for pixels

by Scott Huish
Replies
10
Views
262

Re: Univers and Channels for pixels

Here is the sample you gave, but I don't understand what math you use to get the number for each column after the value you put in Column A. Can you please clarify?

<b>Excel 2010</b><table...

by Scott Huish
Replies
5
Views
54

Re: =if(condition,,)

Just to return TRUE/FALSE:
=E2&gt;50
10. Thread: INSERT A SPACE INTO A TEXT VALUE

by Scott Huish
Replies
47
Views
241,698

:eeek:
11. Thread: "Greater than" > rersults

by Scott Huish
Replies
4
Views
145

Re: "Greater than" > rersults

Personally, I would use COUNT, but same principle:

=IF(COUNT(H4,J4)<2,"",IF(H4>J4,C4,O4))
12. Thread: IF "x" is within all columns

by Scott Huish
Replies
4
Views
101

Re: IF "x" is within all columns

=IF(COUNTIF(A1:IP1,"*exclude*"),"exclude included","exclude not included")
13. Thread: VBA Close With Save Causes Runtime Error

by Scott Huish
Replies
1
Views
100

Re: VBA Close With Save Causes Runtime Error

by Scott Huish
Replies
8
Views
183

Re: If Statment Help

Like 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:...

by Scott Huish
Replies
8
Views
183

Re: If Statment Help

Perhaps:
=IF(AND(A2<>"",C2<>""),A2&" "&REPLACE(C2,1,FIND(" ",C2),""),IF(C2=C1,B1,""))

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border:...
16. Thread: Finding row number of the last date in a given month

by Scott Huish
Replies
3
Views
198

Re: Finding row number of the last date in a given month

That won't work because the amount of dates in May is greater than the largest value in that sample.

Perhaps:
=LOOKUP(9.99999999E+307,IF(TEXT(B2:B5,"mm/yyyy")="05/2019",B2:B5),ROW(B2:B5))
...

by Scott Huish
Replies
7
Views
363

Re: A better formula?

More specifically, if it contains a non-zero number, it would return 1. If it contained 0, it would return 0.

by Scott Huish
Replies
7
Views
363

Re: A better formula?

Yes, if a number is in that spot, non-zero is TRUE and zero is FALSE.
19. Thread: VBA to extract variable length number, following a variable character

by Scott Huish
Replies
17
Views
516

Re: VBA to extract variable length number, following a variable character

=LOOKUP(9.999999999E+307,MID(A2,FIND(".",A2)+1,ROW(INDIRECT("1:15")))+0)

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

by Scott Huish
Replies
7
Views
363

Re: A better formula?

You could shorten it a little bit by writing it like this:
=IF(A2*B2,C2/ABS(B2),SIGN(C2))

by Scott Huish
Replies
4
Views
106

Re: Formula Help

=MEDIAN(10,A1,100)

by Scott Huish
Replies
9
Views
246

re: Nested formula problem

You shouldn't put numbers in quotes, that makes them text.
=IF(AND(X3<15,X3>7),1,IF(AND(X3<80,X3>0),2,IF(AND(X3<0,X3>-3),3,IF(AND(X3<-3,X3>-3),4,"N"))))

Your last choice doesn't make sense though...
23. Thread: SUMPRODUCT error when blank cell

by Scott Huish
Replies
8
Views
358

Re: SUMPRODUCT error when blank cell

Ok, but blanks still evaluate to 0. Do you mean they're not actually blank, as in empty string "" or space " " or what?

As you can see, it's not failing as you have described the problem:
...

by Scott Huish
Replies
9
Views
246

re: Nested formula problem

I would check the entire range at once:

=IF(COUNTIFS(X3:AB3,">2",X3:AB3,"<4")=5,"Yes","No")
25. Thread: SUMPRODUCT error when blank cell

by Scott Huish
Replies
8
Views
358

Re: SUMPRODUCT error when blank cell

If columns B & E are actually empty, that would equate to 0 in your formula. So what is your problem exactly?
Results 1 to 25 of 150
Page 1 of 6 1