Hi David You can convert the numbers to text format using the TEXT formula. My macro will export your data to CSV but not sure if the result is ...
Hi Paul My 2nd attempt I created a helper row 7 that concatenated rows 8 and 9 to create a unique value. I then use the same technique as my ...
Hi Paul The data that you gave us earlier is very different from the one you gave us now. The suggested solution is based on what you gave us earli...
Hi Paul Take a look at the attachment. The final formula may look complicated but the logic is easy to understand. Hope this helps. Sunny
Hi B B Welcome to the forum. It is not necessary to hide the rows. Since you already have 7 fixed ranges, I have included 6 check boxes for y...
Hi Paul If your data is consistent, you can use INDEX/MATCH. To get the 2nd row (Occupancy%), just add 1 to the MATCH value. Please refer to ...
Hi Steve I had to use VBA as I am unable to find any formula that would give me the same result. If you find any, hope you will share it with us...
Hi Steve See if my examples help. Some are not so elegant. Sunny
Hi Melinda Thanks for your feedback. Sunny
Hi Milena Glad to know you got it solved. Sunny
Hi Melinda Hope you don't mind that I hard-coded the ranges. Cheers
Hi Melinda Give this a try. I created a temp sheet with the names, sorted them and write back to the worksheet. The temp sheet is then delete...
Hi Melinda I don't quite understand your question. Is it sort by columns or rows? If you can provide us the expected result from your attachment...
There is no attachment
Hi Milena Welcome to the forum. Just select the required range and then run the macro below. Sub DeletePictures() Dim Sh As Shape For Each Sh...