Rachel Hettinger

less info
366 reputation
18
bio website
location California
age 44
visits member for 2 years, 7 months
seen Jul 2 at 19:03

Apr
28
awarded  Caucus
Dec
16
comment Excel: Check if column A has any values from Column B, and delete that value from Column A
You could put a formula in column C like: "=NOT(MATCH(B2,A:A,0))" that would provide an error value in the proper rows, but you would still need to delete the values one-by-one.
Dec
3
awarded  Yearling
Jul
12
awarded  Caucus
Feb
1
awarded  Cleanup
Feb
1
revised How can I sum a series of tabs across tabs?
rolled back to a previous revision
Jan
31
answered How can I sum a series of tabs across tabs?
Jan
29
comment Excel: make HYPERLINK and INDIRECT to work on the same sheet
In order to link to a cell in another workbook you can enter the link as shown in my first example or use the INDIRECT function.
Jan
28
comment Excel: make HYPERLINK and INDIRECT to work on the same sheet
@clabacchio No, sorry. Those are your choices.
Jan
26
awarded  Commentator
Jan
26
comment Excel: make HYPERLINK and INDIRECT to work on the same sheet
@clabacchio I updated my answer to include another option. However, you either need to directly link to the external file (first example), or the external file needs to be open (second example).
Jan
26
revised Excel: make HYPERLINK and INDIRECT to work on the same sheet
Added use case for INDIRECT
Jan
26
answered Excel: make HYPERLINK and INDIRECT to work on the same sheet
Jan
12
comment Stop “Excel formula or sheet contains the name” dialog
The best way to handle the first message box is to click Yes. You will get that message for every similarly-defined & used name... Use the Name Manager to see how many named ranges you have.
Dec
28
awarded  Critic
Dec
28
comment VLOOKUP when Lookup Value is a cell populated via another formula
@Jay FWIW you can always edit your answers to improve or correct them. You can also delete comments.
Dec
22
answered Excel Conditional Formatting of Rows based on multiple columns
Dec
7
comment Display a value next to a cell containing a maximum value in a range.. Excel 2007
BTW: If this answers your question, you should select it as such.
Dec
6
answered Why is Edit->Links disabled when I open my sheet?
Dec
6
answered How to chart different shifts run times in Excel 2003