@Lalit,
Thanks Brother. I did Ctrl+Shift+Enter to effect formula as Array Formula, but still error persist.
Type: Posts; User: analyst
@Lalit,
Thanks Brother. I did Ctrl+Shift+Enter to effect formula as Array Formula, but still error persist.
I'm closing this thread, as it is. Thanks for all the support, fellow members. I'm also exiting from this forum, trust no offence.
Once again thanks for all the support that you all extended to...
Thanks Lalit. I did as you suggested, but in every cell, there is an error - #NAME?.
Revised book is attached. Please guide/do the needful. Thanks a ton for suggestions.
No idea, where i've...
I think moderators are not around, and few ill motivated members are spamming the forum creating annoyance.
Does above make sense? Is it too difficult? Or having seen no answer, should i close this thread?
Seek, Senior's guidance.
Logically what I've done is to filter data table from row 19. From Column A, select down filtered rows, and copy data and paste special as values from Row A3. Later, using nested formula Index and...
@ alansidman,
Agree , but doing this again and again for four tables is cumbersome, with other routine works on daily basis.
So, using some nested formula, IF each column could bring relevant...
Should I modify the query to have VBA macro, instead of having Formula in place, Here only?
Any help here :confused:
I've sheet1 where Students Name, Marks, Passing Status etc (Pass, Fail, ATKT) are given based on some Ranking system, for current Year (Range A19:F73), and for last 5 years (Range H19:M73).
Row...
Got the solution, was not properly put the brackets
the solution is like
=IF(OR(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),AND(((K221>=50)),((K222/K221)>=5))),Z222&" Shock","")
To combine above formula, I am trying following which gives error
IF(OR(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),((K221>=50),((K222/K221)>=5))),Z222&" Shock","")
I have two formula, which I require to merge to have one single formula:
Formula 1
=IF(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),Z222&" Shock","")
Formula 2
Kindly delete this post apology
@p45Cal
Thanks Brother, the above code works, except what is sought at Serial No. 5,6,7 in post #1, however is not done properly. I mean where there is no pair of row having data in Column E "YY",...
@ Thanks, Admin
This could be nice code, when someone is running a big procedures, and not sure whats going on except mouse pointer turns as hourglass.
I guess, the main Macro/Code/Procedure...
Anybody looking at this query, or should I modify? :(
Sir,
I've posted part of the solution, what I was knowing through learning from the Forum.
I am looking to solve this, kindly give the solution to this query. Thanks
Row 1 is the header so, it should not be deleted
Data Range starts from A2 and across column O, and rows could vary from 25000+
Now Macro should perform as under
1) First delete all rows where...
Data range starts from A9:M9, and last row varies on day to day basis.
Adjacent cells like A1:M8, have data, which should not get disturbed.
Column B has identifier flag, which in case is not...
I just tried this, I guess this is right!!!
=IF(AND(Z6>=2.5,OR(AA6>AA5,AA5>AA4),(AA6>=AA4*0.9)),"New","Ignore")
My current Formula is as under
=IF(AND(Z6>=2.5,AA6>AA5,AA5>AA4),"New","Ignore")
Now, within same formula, if above condition is not met BUT following condition is true, then also, it should...
COrrected, I was calling separate procedure to sort the data, where I made mistkake.
Correction in code, is as i mentioned in # 7, and as suggested by Brother bakerman #8. Thanks.
Versatile...
@bakerman,
Thanks, I did that also as A:O is 15 columns, and Column P would be 16th Column.
Albeit with that also, macro gets executed, data in Column P is not correctly brought in line with...
Dear Admin,
Which line should be changed to what, (solution given in # 3 above), if i expand one more column upto P (Column P has only numeric value), and data test is now for 6 days, instead of 4...