Hi Learning2 See if this is what you wanted. Please do not key an asterisk (*) in cell A1. Just enter 1234 and it will search for all file names...
Give this a try.
See if this is what you wanted.
Perhaps you can give this a try for part 1 of your question. Don't understand your 2nd question. Maybe you can elaborate a bit more and give some e...
Hi Dave It is difficult to give an answer without looking at some sample calculations. Maybe you can try something like the attached. Sunny
Hi David The explanation is a bit long so hope you can understand COLUMN F The formula consists of 2 parts. Part 1 COUNTIF($C$2:C2,C...
Hi Dave The apostrophe is required in your case as the worksheet name referred to consist of more than one word. The normal formula would look l...
Hi David Do you really need a macro? Can you settle for some formulas? Refer column F and G for my answers (based on the answer you supplied). Or d...
Hi Hava It does not matter what you entered in the Current Month date cell. If you entered 13/04/2016 it will be converted to either 30/04/2016 (E-...
Refer attachment.
Having problem uploading attachment. Will try again later.
Hi mey See attachment. Sunny
Hi Craig Perhaps you can try this. In cell C3 of ther Reference sheet, enter the following formula (array entered) and then drag down as many rows ...
Hi Canapone No problem. All are welcome to help. We can learn form each other. Hi Adrian Refer another option.
Hi Adrian Unable to replicate your problem. Maybe you can attach an example. Sunny