Search:

Type: Posts; User: Bob Phillips; Keyword(s):

1. Thread: Forgot Formula, and can't find it

by Bob Phillips
Replies
2
Views
420

Just use =A1*A2 with a custom format of...

Just use

=A1*A2

with a custom format of \$#,##0.00"ea"
2. Thread: █ Automatically transferring data between worksheets █

by Bob Phillips
Replies
2
Views
4,265

Use this formula in TeacherView ...

Use this formula in TeacherView

=IF(ISNA(MATCH(\$A3,'Class view'!B\$2:B\$11,0)),"",INDEX('Class view'!\$A\$2:\$A\$11,MATCH(\$A3,'Class view'!B\$2:B\$11,0)))
3. Thread: Pasting a volatile formula in Excel 2007

by Bob Phillips
Replies
4
Views
1,565

Shouldn't you refer to a single cell, not the...

Shouldn't you refer to a single cell, not the whole column

=VLOOKUP(OFFSET(F2,0,-2),'Lookup current policies.xlsx'!ExpiryDates,2,0)

by Bob Phillips
Replies
2
Views
563

You can't divide a cell or pair of cells...

You can't divide a cell or pair of cells diagonally, but you could overlay a triangular shape with a high transparency factor. But I have to ask what is your objective. Having a value in one of the...

by Bob Phillips
Replies
20
Views
1,336

The real requirements are slowly seeping out, I...

The real requirements are slowly seeping out, I bet we haven't got them all yet.

Try this

=IF(AND(D3=H3,ISNUMBER(MATCH(E3,\$I3:\$O3,0))),INDEX(\$I\$2:\$O\$2,1,MATCH(E3,\$I3:\$O3,0)),"")

by Bob Phillips
Replies
20
Views
1,336

Try this array formula ...

Try this array formula

=IF(ISERROR(MATCH(D3,\$H\$3:\$H\$7,0)),"",MIN(IF(\$I3:\$O3<>"",\$I\$2:\$O\$2)))

by Bob Phillips
Replies
20
Views
1,336

That is what my formula does.

That is what my formula does.