Recent content by santhoshkunder

What does 9^9 do here?

Please help me achieve this. Material Month Price Latest Price A Jan 10 B Jan 2 2 C Jan 4 D Jan 5 5 A Feb 8 8 C Mar 22 C April 19 19

Can someone help me with a method to identify the ideal price in the below scenario to reach the volume of 1700?.. How to achieve this? Year Price Volume 2018 4.75 1500 2022 6.03 1300

You are a genius!:)

Please help me achieve this! Name Month Sal Average ABC Jan 2 ABC Feb 4 ABC Mar 6 4 XYZ Jan 5 XYZ Feb 10 XYZ Mar 15 10

Thanks. Works a treat!

Please help me achieve this!

It is XL function. I resolved it. Thanks

It should encode the text so that it will be used as an URL.. The whole logic is with that formula I should be able to create a dynamic url which users can click on.. Without encoding: This is test with encoding : This%20is%20test( This is fit for URL creation)

Here is the sample file

I get #VALUE! with this formula HYPERLINK(HYPERLINK(Config!$B$9&"/"&SUBSTITUTE(TEXT(E38,"MM/D/YYYYY"),"/","_")&"/"&ENCODEURL(Config!$B$10))&"/"&ENCODEURL(A38&".msg","Click") Config!$B$9= https://kt001-kt.kell.com/:u:/r/sites/AAFAA3444/Connectivity/Connectivity Controls Audit...

Hi All, Is it possible to open two links at once from an Hyerlink function. Example: =Hyperlink("https://chandoo.org/ "&"https://stackoverflow.com/ ") Thanks

Amazing. It worked!. Thanks

How to achieve conditional average. I need average wherever there is "D" , When there is no "D" then it has to calculate the average for "R1". Thanks santhosha'

Any help please!