Dear Friends,
In a worksheet around more than 3000 rows are there. Columns A:J are filled with data.
After deleting rows based certain conditions, the number of rows are reduced to around 500.
Now, in column K, I would like to apply a formula like, =sum(a2,d2,g2) in all such existing 500 rows.
Thanks in advance.
so you probably know your last row
if not find it (may be like:
The main task (filling with formula) could be:
Please Login or Register to view this content.
Please Login or Register to view this content.
Best Regards,
Kaper
Dear Kaper Sir,
I do not know what is wrong in Filling Down the applied formula.
The problem I am facing is:Please Login or Register to view this content.
When executed, the output by macro is:Whereas the output should be:Please Login or Register to view this content.(i.e. "MyLRow is not applied as absolute reference").Please Login or Register to view this content.
Last edited by acsishere; 10-19-2017 at 08:46 AM.
Good friends are hard to find, harder to leave, and impossible to forget.
acsishere.
But ... result of these two:
Formula:
Please Login or Register to view this content.
is exactly the same. Difference between relative/absolute/mixed addressing is important only on the stage of copying formulas. Once formula is in a cell, it is exactly the same if you use:
sum(A1:C1), or sum(A$1:C$1), or anything else, like $A$1:C1
At the moment of formula calculation it in all above cases sums values from cells A1:C1
Then, if the formula is filled-down, the last row value is increasing by one.
i.e. in row 3, it is D22;
in row 4, it is D23;
in row 5, it is D24;. and so on.
How to make it right & fix it? Please help me.
Last edited by acsishere; 10-19-2017 at 01:25 PM.
Sir, please let me know what is wrong in this code?: (When run, in next row the value of lastrow [MyLRow] is increasing by one (like in row 3, it is D22; in row 4, it is D23; in row 5, it is D24;. and so on.)
Please Login or Register to view this content.
Last edited by acsishere; 10-19-2017 at 02:52 PM.
I do not understand what this formula is supposed to do.
Please Login or Register to view this content.
Last edited by mehmetcik; 10-19-2017 at 02:59 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Sir, The formula returns "rank" based on certain groups. The macro given by you is copied in a sample sheet and attached.
Same result. Unable to understand what is the problem. Please check it Sir.
Last edited by acsishere; 10-19-2017 at 03:10 PM.
As a guess put this into J2 and fill down.
Formula:Please Login or Register to view this content.
Why not manually type the results that you expect in column J to give us a hint at what you are trying to do.
Sir, I have mentioned the sample output in the attached file (along with my previous reply) file name query92.xlsm.
Request your kind perusal, sir.
Last edited by acsishere; 10-19-2017 at 11:01 PM.
Any help, pl.
How about this ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks