Hi,
Pls find the attached solution. The trick is to use wild card
character. The limitation is that the text should not be repeated in
any other cell or else the result may not be as per expectation.
2009/4/3 hari :
> Hi All,
>
>
>
> I would require the output “city name from sheet “Data” on i
You can use this tip
While keeping the "ALT" key pressed, press the down arrow key which will
display the list of values. You can select the value using the down or up
keys.
On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote:
>
>
> The fill handle is very helpful for filling cells with various va