I was making a shopping sheet of products in rows, with columns being shops, and cells being prices. I wanted to find the cheapest price for each product. This was exactly what I needed! List of shops for the reference for INDEX, then MATCH to find the row with the smallest value.
@helloworld3656 жыл бұрын
Best tutorials 👍👍👍
@anisly42426 жыл бұрын
Brilliant. I knew there should be a way...
@MrPianoMatt122 жыл бұрын
thanks helped me a lot
@sammiller98557 жыл бұрын
Great Tutorials!
@jaworskij7 жыл бұрын
yeah, but you have to set the speed to 1.5x to fix the pacing
@sammiller98557 жыл бұрын
I personally like the more relaxed paced. Some of the other excel videos I've watched feel a bit rushed.
@sadashivdaruwale36144 жыл бұрын
Very nice video
@esperantoestaslaespero.935 Жыл бұрын
How to use index and match in 2 cell together. Example when I select Product Name, give the product ID and i when select Product ID give me the product name.