Replies

As long as that Named range is one cell.

J. Walkenbach offers a different solution.

Suppose Range (A1:A1000) is named Data, and “text” is the name of cell B1. Then if not case sensitive, the formula is:

=COUNTIF(data,text) (not array entered)

But if it is case sensitive, then this formula works:

=SUM(IF(EXACT(Data,text),1)) which is array entered (CSE)

My question: Is there an advantage of this case sensitive formula vs. what was posted?

J. Walkenbach offers a different solution.

Suppose Range (A1:A1000) is named Data, and “text” is the name of cell B1. Then if not case sensitive, the formula is:

=COUNTIF(data,text) (not array entered)

But if it is case sensitive, then this formula works:

=SUM(IF(EXACT(Data,text),1)) which is array entered (CSE)

My question: Is there an advantage of this case sensitive formula vs. what was posted?

Sounds like SUMPRODUCT:

=SUMPRODUCT(($A$1:$A$20=”Job Code”)*($B$1:$B$20=”Date”),$C$1:$C$20)

Put in the Job code and date as necessary (if they are formatted as numbers then omit the ” marks), and this will give you the total for each Job code on a specific day.

Sounds like SUMPRODUCT:

=SUMPRODUCT(($A$1:$A$20=”Job Code”)*($B$1:$B$20=”Date”),$C$1:$C$20)

Put in the Job code and date as necessary (if they are formatted as numbers then omit the ” marks), and this will give you the total for each Job code on a specific day.

[indent]

---

=INDIRECT(“‘Sheet1!'”&CELL(“Address”,A1))

---

[/indent]

Just a question regarding this formula. I tried it this way, but received #REF. However, if I removed the single quotes (‘) around “Sheet1” then it worked. Is there are reason the single quote?

[indent]

---

=INDIRECT(“‘Sheet1!'”&CELL(“Address”,A1))

---

[/indent]

Just a question regarding this formula. I tried it this way, but received #REF. However, if I removed the single quotes (‘) around “Sheet1” then it worked. Is there are reason the single quote?

Not sure, but F5 gives the Go To command, whereas F3 provides Paste Name box.

Not sure, but F5 gives the Go To command, whereas F3 provides Paste Name box.

Press F3.

Press F3.

Yes, I had taken all add-ins out and the problem persisted.

After following Jan’s post carefully, and still no results, I checked one final place (My Documents…ExcelXLStart as opposed to Program FilesOffice) and there was an extra file there with the name XLStart.xla. I removed it from the folder and no more problem.

Thank you both for offering the advice and the process of detecting the problem. Much appreciated!

Yes, I had taken all add-ins out and the problem persisted.

After following Jan’s post carefully, and still no results, I checked one final place (My Documents…ExcelXLStart as opposed to Program FilesOffice) and there was an extra file there with the name XLStart.xla. I removed it from the folder and no more problem.

Thank you both for offering the advice and the process of detecting the problem. Much appreciated!

As long as the person clicks inside a text box, the margin indicators will show, even in Normal view.

If you want to change where the items are lined up, then you will have to change the level associated with that specific text.

As long as the person clicks inside a text box, the margin indicators will show, even in Normal view.

If you want to change where the items are lined up, then you will have to change the level associated with that specific text.