|

Excel Genius

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like
Arrow Icon

Thank you so much for helping me complete my shopping list, Excel. Would have forgotten my oysmonrs and fmoyur without you. Happy thanksgiving, everyone! Hope you all get a chance to disconnect and enjoy some quality time with loved ones tomorrow!!

Post Photo
funnylike
Arrow Icon

How would I create subtotal rows in a table? A true table, I dont want to turn my table into a range because I need the other sorting features.

likehelpful
Arrow Icon

Is there anyway to move word survey questions to corresponding cells at Excel? There re 80 questions of them and would drain me to move them one by one

like
Arrow Icon

Vlookup won’t lookup values in a sheet even after format pasting from an excel sheet that does work....plz help

like
Arrow Icon

Is there a way to use the trimmean function in a similar manner of AVERAGEIF? I have a a database that I want to calculate the average excluding the top and bottom values (not necessarily the higher … more

like
Arrow Icon

Is there a way to increase the value of a cell every 10 cells by an amount? Trying to make a cvp and i don't want to divide the amount by 10 for the slope. Thanks!

like
Arrow Icon

Convinced my non-accountant-but-still-works-@-B4 wife that Excel doesn't use the letter O at all because it's too similar to 0. And that most accounting systems don't use O either. Score … more

likefunny
Arrow Icon

If I have 2019 value, and 2018-19 YoY growth, what is the easiest formula in excel to calculate 2018 value? I know this should be easy so sorry I’m dumb

like
Arrow Icon

Excel newbie, need help. Is there a conditional format that if A5=2, then A3-6 get highlighted in a color. Same as you increase the numbers e.g A5=3, then A4-6 ger highlighted in another color.

Post Photo
likesmart
Arrow Icon

Why am I just now learning the proper function?

likefunny
Arrow Icon

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distributio… more

like
Arrow Icon

Does anyone know what the “--“ in the below does to the formula? Or how excel reads it? Everyone I work with that uses it only say, ‘idk but it’s required for the formula to work.’ Would just like a b… more

like
Share this 🔥 post
Arrow Icon

I am running a macro that uses "Application.FileDialog(MsoFileDialogType.msoFileDialogFilePicker)" to select a single workbook file and then open the selected workbook. Cell A1 on Sheet1 o… more

like
Arrow Icon

Having trouble with data dependent drop down list. In sheet 1 I have “type” and “subtype” columns that are blank and I need column B to be a data dependent drop down of A. The master data is the forma… more

like
Arrow Icon

I have tables in multiple sheets (cannot put in one) i want to create one consolidated pivot table using all these tables, I tried to use “multiple consolidated ranges” option, but the pivot table is coming in the form of ‘Column’ and ‘Rows’ instead of actual rows and columns (see image) Any solution? TYSM

Post Photo
like
Arrow Icon

Excel file w/ 500k+ lines of sales transactions and I want to pull all the transactions for ~100 customers. Customers have unique customer ID no. but I can’t highlight duplicates since customer

likefunny
Arrow Icon

I'm stumped! Coworker creates "Sheet A" with invoice numbers I use Monarch to extract invoice #'s and amounts from another report. I do a pivot table to compile amounts by invoice.… more

like
Arrow Icon

Any non-VBA formulas to move data from the format on the left to the table on the right? Not manual copy/transpose/filter, but something that would be able to auto-convert new data from left format to right.

Post Photo
like
Arrow Icon

Is there a way to restrict character count, or note characters over X number, in a cell? (Ideally, like Twitter where you can see how many over and decide whether to proceed) — or is there an alternat… more

like
Arrow Icon

The “get and transform” feature I am going to have to play around with. Seems like it could make partner allocations so much easier for example most of today I spent taking data from one workbook to… more

like
Arrow Icon

I have 10 columns in my doc but only need to transpose column 3 & 4. Would usually do this in python but client’s laptop would not let me install anything. Any clue on how I can do it on excel? Th… more

like
Arrow Icon

Anyone know the shortcut to format selected cells as short date IE mm/dd/yyyy?

likesmart
Arrow Icon

Is there a simple way to say if a cell being referenced is visible give me the value, if it is grouped away, give me an error? Ie. = IF( E69 = Visible , E69 , N/A )

like
Arrow Icon

I have a large binary file (20mb) . When trying to reference another workbook in formula, excel won’t recognize the other workbook. Any fixes? I’ve been trying to reduce size

like
Arrow Icon

Looking for a consultant to implement ODBC links with Power BI. Any thoughts on what I should be asking a consultant and/or what they should be asking about the job?

like
Arrow Icon

What is the good training for excel? Do you guys have any good youtube channel?

like
Arrow Icon

Using PowerQuery in Excel I want to check all these columns and if all the values on all the columns = TRUE for a row, then return Compliant. Currently its doing else if, which is wrong

Post Photo
like
Arrow Icon

What’s your most useful shortcut that isn’t commonly known (i.e. CTRL-C/CTRL-V)?

Post Photo
likefunnyhelpfulsmart
Share this 🔥 post
Arrow Icon

Does anyone know how to index match with an IF statement? I have the index match complete, but now I need to edit that formula so that if the value equals 0, the cell displays the value in B5.

like
Arrow Icon

Can I round without using formula? Like with cell formatting? Eg. $1,234,567.99 $+,+++,; result = $1,234 but want the 4 to round up (using + instead of hashtag)

like
Arrow Icon

Trying to do a calc to identify goal opportunities/risks. For example, I’m at 83%. My goal posts (my array)are 50%-100% in increments of 10%. If I get to 90% I get pts. Conversely I’m at risk of losi… more

like
Arrow Icon

Want to use vlookup match to obtain cel value but really require value n column to the right. Please help

like
Share this 🔥 post
Arrow Icon

Help please! Have a column with the data “1. Expired” and trying to create a new column that will only say “Expired” (delete the “1.”) Im trying different combos of RIGHT and FIND but can’t seem to g… more

like
Arrow Icon

What is the best way to summarize data when it is organized by rows (rather than columns)?

like
Arrow Icon

In excel, whenever run a command that requires a pop up (like paste special or data validation), it clicks off of it (I.e., I can’t use the keyboard anymore and have to manually click back into the ex… more

likehelpful
Arrow Icon

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like
Arrow Icon

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

like
Arrow Icon

Excel Geniuses, please help: Is there a way to display data in a Scatter chart (or any chart for that matter) that changes based on a condition (IF, AND, OR)? For instance, if I have a list of data… more

like
Arrow Icon

I’m manually comparing work that someone else did to a balance sheet. Is there a macro or something I can make to make it more efficient? I’m using vlookups now but it’s so time consuming

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.

Already a user?
Login here

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