Reputation
535
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 8 22
Impact
~123k people reached

  • 0 posts edited
  • 0 helpful flags
  • 30 votes cast
Apr
1
awarded  Yearling
Apr
1
comment Find last row in sorted table for matched value
Disregard that. I was able to workaround this issue by making the initial cell an array function, then dragging the array function down to fill in the remaining table rows.
Apr
1
comment Find last row in sorted table for matched value
This partially works. If I make each individual cell an array, then it pulls the correct date. If I don't and instead make the entire table an array, then it only uses the first order number (A13) as the comparison. How can I make this a true array function so I don't need to manually set each row as an array? I tried =MAX(IF(A1:A6=A13:A14,B1:B6,"")) but that returns #N/A. Why is the array function not correctly pulling the partial-sample order#?
Apr
1
awarded  Teacher
Apr
1
answered Microsoft word reformat lines to take up entire line
Apr
1
asked Find last row in sorted table for matched value
Feb
1
comment Microsoft mail merge incorrectly formatting numbers
This worked. The text formula is not necessary, though, as it turned out I simply needed to change the cell format from number to text.
Feb
1
accepted Microsoft mail merge incorrectly formatting numbers
Jan
31
asked Microsoft mail merge incorrectly formatting numbers
Jan
9
answered Excel 2007 Images Embedded In Comments = File Too Large
Jan
8
comment Interpreting PHP offline?
@tkbx if you install a server on your home computer you won't have to deal with FTP or uploading at all. At that point it is just a drag and drop on the local filesystem.
Jan
7
accepted Outlook mail template variables
Jan
7
comment Coloring partial text within cell in Excel
@chuff Yes, I was building them up as strings so I could get around the grid limitations of Excel (fixed width column size for each row).
Jan
7
accepted Coloring partial text within cell in Excel
Jan
7
answered Coloring partial text within cell in Excel
Jan
3
asked Coloring partial text within cell in Excel
Oct
11
awarded  Popular Question
Aug
7
awarded  Famous Question
Jun
4
asked Using to/cc/bcc in Outlook contact group
Apr
5
awarded  Tumbleweed