Replied to the thread Search, Data Input and Create Hyperlink ( The Complex Thought).PostThank You S O
I am attaching the file (First Sample File.xlsm) for better understanding.
Thank you again.
Replied to the thread Search, Data Input and Create Hyperlink ( The Complex Thought).PostHi, welcome to OzGrid!
It would help if you could provide a worksheet that has an example of the data you are using, this helps to see the problem and create a better solution.
Replied to the thread Conditional Weighted Averages using SUMPROD and IF Statements?.PostSee the new formula with the yellow background, making use of SUMPRODUCT
BTW, are the blank rows necessary? If not they can be removed and you can make your range an Excel Table.
Then rebuild the formulas provided using the table references, so that in the…
Posted the thread Search, Data Input and Create Hyperlink ( The Complex Thought).ThreadHi.
I have worksheets with lots of data and various related certificates in the drive location. The fact is I want to create a hyperlink. Now, how the hyperlink create?
The File Location folder is D:\Certificate\ where the file name is like 5.…
Hi, Hope All Are Fine.
I have a worksheet where I want to input date to a specific column of the selected cell if I click on a command button.
The selection data range F10 to F1200 & the date input column is AW
The procedure is :
If I select some cell in…
Posted the thread Conditional Weighted Averages using SUMPROD and IF Statements?.ThreadHello -
I'm trying to find Weighted Averages of Column C and D, by letter in Column A.
As the placement of this file will change, how can I find weighted averages of the rates without having to use SUMPROD in specific ranges, since placement will change…