Nov 27 2020 09:09 AM
hey guys, I am trying to code a search of a cell value. I want to print in another sheet all the row results. i have used vlookup to find the result and countif for the number of rows but I can't get the rows in the new sheet.
Can anyone assist me plz?
thank you
Nov 28 2020 05:38 AM
@shawndotting You do not need to post your data if it is sensitive, but you may need to post the structure and we can provide you a better solution.
Nov 28 2020 12:53 PM
With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.
There is no reason for the helper to want to reconstruct everything himself, what you basically already have.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 29 2020 08:36 AM
Nov 29 2020 08:38 AM
Nov 30 2020 10:04 PM - edited Dec 01 2020 05:48 AM
I am using office 365. Excel 2016 I think. I have the xlookup option.
Nov 30 2020 10:45 PM
@shawndotting Since you indicate to have XLOOKUP, you should also have FILTER. With this new function it is very easy to accomplish what you describe. With a slight redesign of the Customer Results sheet it could work as in the attached file. No need for VBA.
Dec 01 2020 05:47 AM
Dec 03 2020 08:13 AM
@Riny_van_Eekelen holy snap your a God Sent....
than you thank you thank you
super easy in comparison to the codes I wrote,,,, index,,,min...if...row...column...
thank you
Dec 03 2020 08:19 AM
@shawndotting Glad it worked out for you!!