Excel Genius

25023 members
Discussions, Useful Tips, Resources, Macros, More

Trying to do a logarithmic growth for a 5 year projection. Y1 is 1000, Y5 is 5000. How do I make the 3 years in between a logarithmic output? I’ve seen it done before but can’t get it to work.

like
Reaction Icon Like
Arrow Icon

Hi all - I have a series of cells from a report that are entered in as ranges ($3.75-4.50 in the cell). I want to pull out the midpoint from this range so that I can use the column in a sumproduct cal… more

like
Reaction Icon Like
Arrow Icon

Whenever I click alt + e + s for copy pasting, the pop up goes out of focus making me click into the excel again before choosing paste options. Anyone know how to fix this?

like
Reaction Icon Like
Arrow Icon

How do you fix microsoft excel cannot paste data error?

like
Reaction Icon Like
Arrow Icon

Hey all, has anyone made a horizontal floating bar chart, where one end of the bar has the min, the other max, and then I want to mark the average?

like
Reaction Icon Like
Arrow Icon

Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client inpu… more

like
Reaction Icon Like
Arrow Icon

Friends & Fish - my team and I are recruiting users for the first round of interviews for the startup we're working on. 🔥 We are looking for : ✅ Team leads ✅ Team leads ✅ Startup CEOs ✅ Team leads ✅ Corporate program managers ✅ Corporate team managers Please DM me, if you have such professionals among your connections. We are offering Amazon gift cards for people we interview.

Post Photo
like
Reaction Icon Like
Arrow Icon

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, whe… more

like
Reaction Icon Like
Arrow Icon

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like
Reaction Icon Like
Arrow Icon

Hi everyone - I have to check multiple conditions in two columns if values are like (1,1) or (1,2)...(1,5) or (2,1) or (2,2) or (2,3)...(2,5)......or (3,1) or (3,2)..... so on upto (5,5) and then acco… more

like
Reaction Icon Like
Arrow Icon

Hi there! I'm working on the data modeling assignment and looking for some tips for data mapping (how power query or vba can help). Thanks!

like
Reaction Icon Like
Arrow Icon

Anyone else seeing @ signs pop up at the beginning of some of their formulas? Does this have something to do with an update..?

like
Reaction Icon Like
Arrow Icon

Does anyone know of any sampling marcos available online or resources to assist in creating one?

like
Reaction Icon Like
Arrow Icon

When using PowerQuery and you get an error trying to combine rows from several files within a folder (something about a key match to the master file...or just any error in general), what is the first … more

like
Reaction Icon Like
Arrow Icon

Is there a way to use formulas within icon set-based conditional formatting? I'm trying to compare D2 vs. C2, E2 vs. D2, etc.. I know I could create a helper table w values

like
Reaction Icon Like
Arrow Icon

Anyone familiar with the fuzzy match add in, and if so, how do you run a fuzzy match within one column of information rather than two tables? I.e., I want to find close matches within one list of vend… more

likesmart
Reaction Icon Like
Arrow Icon

Any good excel shortcuts pdf?

like
Reaction Icon Like
Arrow Icon

Hi folks, trying to use the COUNTIFS() formula, where one of the criteria is to only count unique values within a range. Any suggestions on how to do that?

like
Reaction Icon Like
Arrow Icon

So I still see people use a “green background” for screen glare...not sure if this is still possible in office 365. Anyone want to share how to go about this (other than fill all cells with green colo… more

funny
Reaction Icon Like
Arrow Icon

My firm pushed an update to O365 and now a number of custom Excel add-ins no longer work. Has anyone come across a fix for this or is it an unresolvable compatibility issue?

like
Reaction Icon Like
Arrow Icon

What are PowerQuery and PowerPivot truly good for?

like
Reaction Icon Like
Arrow Icon

Thanks Office update for making me type an @ in my index match formulas now

like
Reaction Icon Like
Arrow Icon

How can I write an if formula that chooses what column to check for based on another cell? Thanks

like
Reaction Icon Like
Arrow Icon

When I paste values, does excel go in to edit mode for the destination cell, and therefore re-calc the work book?

like
Reaction Icon Like
Arrow Icon

Trying to do a countif function and the search criteria is “<50%” like the actual text, but it does not seem to work? I am doing the same function for “50-60%” and it worked but I think the “<“ … more

like
Reaction Icon Like
Arrow Icon

How do I remove line breaks within a cell?

like
Reaction Icon Like
Arrow Icon

Hey. Is there a situation where only an XOR function could be used? Or even generally where is the XOR function used?

like
Reaction Icon Like
Arrow Icon

Hi guys, needing some help here with links. I deleted all the links in my excel file. However, names remain in formulas, and if I open the file, it shows ref errors everywhere ! Copy paste value is no… more

like
Reaction Icon Like
Arrow Icon

What’s the shortcut to move between tabs? I try ctrl+up or down and it just goes to the top or bottom cell

like
Reaction Icon Like
Arrow Icon

Didn’t mean to scare you with my missing two weeks. We’ll resume a weekly cadence from here on out. Please accept my sincerest apologies. Let’s hear some of your best/cheesiest Excel-related pickup l… more

like
Reaction Icon Like
Arrow Icon

I was today-years-old when I learned about hlookup. Been rearranging data to use vlookups all this damn time. 😳

funnylike
Reaction Icon Like
Arrow Icon

Hi! Is there anyway to copy the information and formatting of a pivot table into a new worksheet without copying the pivot table itself?

like
Reaction Icon Like
Arrow Icon

Help unhiding columns A-D in excel. I've tried putting A1 in the select cell selecting unhide columns and also youtube to no luck. Please help.

like
Reaction Icon Like
Arrow Icon

Hey guys- is there a good way to roll forward PY documents and erase PY numbers (leaving formula intact) . Is there a good macro someone can share with dummy data or point me to a good resource (im no… more

funny
Reaction Icon Like
Arrow Icon

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons. How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve). Thank you so much🙏

Post Photo
like
Reaction Icon Like
Arrow Icon

How do I check for the differences between 2 excel sheets? Just trying to find the data the client updated (if anyone knows how to do this in alteryx as well that would be cool since I’m trying to lea… more

like
Reaction Icon Like
Arrow Icon

Could we break IDC related circularity if there are more than 1 debt tranches with different interest rates? Without the use of macro that is

like
Reaction Icon Like
Arrow Icon

I have a list of file names in one column. How to extract the quarter, year and company name in different columns? Is text to column the only way? Looking for a faster approach. Thanks

Post Photo
like
Reaction Icon Like
Arrow Icon
That was just a preview…
Sign Up to see all discussions
  • Discover what’s it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

OR

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

Please enter a valid number