-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
array #n/a user function
-
N
Help to change VBA Array Index Formula to remove #N/A leave blank
Hello Board, I am trying to figure out how I can change the following line of code to leave out the #N/A and just leave the cell values blank. I think that this would be an easy task but I can not figure it out. Range("DS8:DS78").FormulaArray = "=INDEX('Cover...- norman_bunch
- Thread
- Replies: 4
- Forum: Excel Questions
-
Hide #N/A in an Array? ISNA isn't working
I am using a formula to gather data from specified "DATA ENTRY" cell ranges(sheet1!a1:a30) and (sheet2!a1:a30), Into one "SUMMARY" range (sheet6!a1:a60). The cells in the "DATA ENTRY" ranges will have varying ammounts of data input into them. In combination, I am also using a User-Defined...- RumJellybean
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Index and Match between Two Dates
- Started by matthewlouis
- Replies: 33
Hey EXCEL experts, I need a formula for an index and match that looks for a number that is below another cell number. Attached is an image with... -
Tax calculation... IF/AND/OR?
- Started by BrutalLogiC
- Replies: 27
Hello board, I'm struggling with a formula to calculate the tax contribution where there are a number of different salary bandings and rates. I've... -
Largest Letter
- Started by suechetty
- Replies: 25
Hello, I would like a formula to say "OK" if Grade 1 is the highest grade compared to Grade 2 and Grade 3. What formula can I use please? Also... -
Remove characters from a file name
- Started by gtd526
- Replies: 24
Hello, How to remove characters from beginning of a file in a certain folder? I can identify the [U]folder[/U] from a cell. (myPath="A1") File... -
Math operation between a column with unique formulas and another column
- Started by dejhantulip
- Replies: 23
Hello guys! So I've been having this situation quite often, and I have searched and thought of something to solve my problem but haven't been... -
how to export multiple sheets into txt files without the header line
- Started by ankitaugust
- Replies: 22
Hi Folks- I am trying to figure out a simple way to export multiple sheets in my excel workbook without the header line. I was able to export the...