I am completely new to creating formulas in excel, and would be most grateful if you could help provide a formula that will help me do the following:
I have a column of text in say Column A. My formula will be entered in say cell C1. I want to be able to put a text value in cell B1 and for the formula to search for a matching instance of that same value in column A, and if the instance of that text is found more than once, for the formula to randomly pick one of those instances and return the contents of that entire cell in cell C1.
Here's a mock-up image of my example:
Therefore, in the example above, every time the sheet is re-calculated, C1 will return either the value Pink Shoe, Tickled Pink, Pink Spots or Pinky & Perky.
Hope the above makes sense, and your input would be greatly appreciated!