HI,
i have an index match formula in K778:K779. which is working correctly. but i want to add in formula that if Q37 in order tracking is not filled then it should show result "pending" in K778:K779.
HI,
i have an index match formula in K778:K779. which is working correctly. but i want to add in formula that if Q37 in order tracking is not filled then it should show result "pending" in K778:K779.
Are you still using XL2007 as your profile indicates? I think not. Please amend your profile ( my XL2010 returns unknown functions...)
i use excel only for little works, otherwise i works on googlesheet. but i am thinking one thing that when formula is working in xl2007 then why not in 2010
anyway, plz provide the formula as the conditions i have explained in the post.
I am sure you do not mean Q37 specifically but any cell in column Q ?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
The problem suggested by this in your formula when I open the workbook:
is that there is a user defined function (UDF called DUMMYFUNCTION) missing. This means that the original workbook must be macro-enabled with aa .xlm or .xlms extension. You have given us an .xlsx file that does not contain the UDF.@__xludf
You'll need to provide the workbook containing the VBA.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I don't understand your question.
Provide a copy of the workbook with the UDF in it.
The __xludf.DUMMYFUNCTION is a replacement made by Google to make the file "readable" by Microsoft Excel.
As far as I can ascertain there is no UDF!
here is the link of my original google sheets file.
https://docs.google.com/spreadsheets...gid=1797746507
It must be, otherwise my 365 would be able to read it!
EDIT: Ah! It's a Google Sheet!!! No wonder we can't work with it. It must contain something incompatible with Excel.
I am moving this to the correct forum section.
but i have always got solution in my excel file downloaded by googlesheet as it is. and you are moving this post to another section, i have not got anysolution there before also.
i think that somehow can we combine v lookup that if that particular row is empty then "pending" otherwise whatever is in that row for column Q.
@Ali,
If you are referring to my reply, I have no problem in XL2010 with the supplied file i.e. I do not get any error messages relating to formulae which include DUMMYFUNCTION references..
In K4 then copied down ARRAY formula
IN all formulas you have referred 1000th row as 1000. When drag down it will change. So I have changed it to $1000 so that when dragged reference will not change.Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
I get this:
=IFERROR(@__xludf.DUMMYFUNCTION("IF(B793="""","""", IF(ARRAY_CONSTRAIN( IFNA(FILTER(COLUMN('BATCH TRACKING'!K793:BF793),ISBLANK('BATCH TRACKING'!K793:BF793)),0),1,1)=19,""Completed"", IFERROR(INDEX('BATCH TRACKING'!A$3:BF$3,1,ARRAY_CONSTRAIN( FILTER(COLUMN('BATCH TRACKING'!K793:BF793),IS"&"BLANK('BATCH TRACKING'!K793:BF793)),1,1)),""No date data"")))"),"")
...as do I, Ali.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I'm not helping with this, sorry, as I have no knowledge of Google Sheets. My response was merely as a reply to John.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks