Hello Experts
I stuck again with some data and that kills too much time.
Required-
1. Input Data Manually at 'J3' to 'J62' continue day by day
2. on the top data table find the data on the previous date, and if match it then 'found data' sat on the same row. Example- If data 'AOL' on 'J49' found in the top table any row, it's automatically sat on the 'same row' from the 'B1:AE36' array.
3. Same operation for the next column for everyday.
It will be a great help, pls....
kmaient
Im confused
Does the top table feed the bottom table, or does the bottom table feed the top table?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for your concern. I am not good enough in English.
Bottom table feed the top table.
Try pasting the following array entered formula** into cell J2:Formula:
Please Login or Register to view this content.
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Once the formula has been activated, drag the fill handle down to cell J37 and then, while J2:J37 are still selected, drag the fill handle over to cell AE37.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thanks for your support. But, It does not work properly.
Probably, I can't make it understandable properly. Ok, I delete my post and repost it properly.
Last edited by kmaient; 11-15-2020 at 04:21 PM.
Try the following modification to the array entered formula for J2:J40
Formula:Please Login or Register to view this content.
Note that this assumes there will be 20 pieces of input data each day.
As Pete_UK stated, please do not start duplicate threads.
Let us know if you have any questions.
This modification to the formula in post #6 allows for there to be less than 20 pieces of input data for each day:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
JeteMC,
It's really working! I can't understand how I thank you. It's really great that your support and helping hand.
I really wish you every success in your life.
Regards
kmai
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
Hi JeteMC,
How are you? Do you remember u help me to solve my great problem, which saves me more time.
But, when I move for a new file with more data it's not working, however, I change the data range accordingly. Would you please help me again to fix it?
For your time saving, I repeat the task-
Requiments
1. My Source Data in 'B2:B320'
2. I input daily my data in row 326 to 355 from 'C' to 'BE' continue each day.
3. I want to match data with the 'B' column with my Input Column (as per no. 2 Requirements).
Please help me.
Regards
K. M.
Last edited by kmaient; 02-10-2021 at 02:45 PM.
When I opened the file I noticed that the formula in cell C2 was not wrapped in brackets {} and so it had not been activated as an array formula.
Upon pressing the F2 key and then holding the Ctrl and Shift keys while pressing the Enter key the formula was activated as an array formula.
After dragging the fill handle down to cell C324 and then over to cell H324, the formula appeared to be returning the results that I would expect.
Let us know if you have any questions.
Last edited by JeteMc; 02-10-2021 at 03:28 PM. Reason: edited text
many many thanks again.
I follow your message and try it. It works nicely.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks