#excel #error

I am using "=@INDEX(LINEST(E$12:E$16,$C$12:$C$16,,TRUE),,2)" now , but I find if I delete a few data , it would turn out to be #VALUE; I want to know how can I get the results without deleting the whole row? Should I add the IF functions?

Hi, I am trying to build a pricing calculator based on our productions. I want to be able to fill in the article code, and return the highest of multiple production cost should appear in the material cost. When I use the MAX function I do not know how to combine this when I have two sources...

I have a Excel macro file that is working in 32 bit environment. But it is not working in 64 bit. My question is pretty similar to this one Excel File not working on one computer but will on another. Here is the code and the x64Solution() function. Private Sub AmnestyFind() Dim nowUTC As U...

WE NEED SUMIFS FORMULA AS PER QUERY...... NOTE.: DIFFRENT-DIFFRENT SHEET IN PRODUCT POSITION IS CHANGE , HOW TO GET TOTAL QTY & RATE AS PER PRODUCTS

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

HOW TO USE REFERENCE WITH "RIGHT OR LEFT" FORMULA FUNCTION ???? EXAMPLE: i Try this Reference "AB156480" =+A2 But I need Output : " AB156-480" How it Possible After reference ????

I need to create a scatter plot that shows the proposed bonus versus the performance rating by employee. We have more than 255 employees so I am getting 255 character limit error. Does anyone have a workaround to this? I have attached a sample of the pivot and of the scatter plot that I need...