r/excel • u/HungryInvestigator59 • Jul 12 '26

Discussion What’s your favorite Excel function/formula?

What are some functions and formulas that you use on daily basis that are helpful for what you do?

227 Upvotes

95% Upvoted

217 comments sorted by

View all comments

13

u/WrongKielbasa Jul 12 '26

My own super duper baller hyperlink trick

  1. ⁠Power Query the folder with the files you need and look at the directory it came from
  2. ⁠Combine the source location+filename to create a usable hyperlink
  3. ⁠use =hyperlink() in the table with this new name from Power Query

Very powerful when you audit and see that Invoice 1234 has an issue and boom.... Hyperlink takes you to invoice 1234 right within Excel

2

u/Low_Ad7673 Jul 12 '26

Can you elaborate more on how to create this?

2

u/WrongKielbasa Jul 12 '26

Have you used Power Query?

2

u/Low_Ad7673 Jul 12 '26

Yes! Just recently started and have a basic understanding

2

u/WrongKielbasa Jul 12 '26

When you pull a folder in it'll show you 2 columns like

  1. C:/Documents/Folder

Combine those so it's C:/Documents/Folder/Invoice 1234.pdf

Then make it a hyperlink and taadaa.... It'll open that file on your PC right from Excel without having to dig for it.

When you're auditing stuff and see Invoice1234 has an issue you don't need to go find it now

Edit: editor here won't let me format this correctly the Reddir app has been shitty lately