Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have returned some hard to follow, bad results that miss the mark.

like
Posting as :
works at
You are currently posting as works at

Use power query. Google merge queries

like

Can you be more specific? Like a description of your problem?

Also by VSlookup you mean Vlookup?

😎=index(,match())
=iferror(iferror(😎,😎),😎)….

This formula only works with the sunglasses emoji 😎, cutting edge.

like

Related Posts

Considering adoption since we’re not seeing success with IVF. Folks here who are adopting - how did you decide btw local (US) and international adoption? What resources have been most helpful so far? In California if that helps.

like

Hi anyone working at Uplers here? I need a referral. Saw an opening at Uplers for Frontend Development role. I have 7 yrs of experience in Frontend. It would be great if someone could refer me for the same.

Uplers

Aussie fishes, is getting a pre-nup (binding financial agreement) in Australia worth it?

Family Law on separation related matters here seem to be very different from the US

like

I have a valid coe and visa of Japan how to search jobs in Japan from India

like

Sometimes memes are the most succinct way to describe your feelings

Post Photo
likefunnysmarthelpful

Does anyone here work in PWC DDV OWT? I just had an interview with a director and now senior manager for the role of experienced associate and would love some help!

like

Hey folks, how much CTC can I expect from TCS? YOE: 9.5 , Domain: Full stack development. Genuine replies only 🙏🏻

like

Anyone rent motorbikes? If so, what’s the best place to do so?

like

New to investing. Looking for any/ all tips... book recommendations, YouTube videos on how to get started

like
like

Do companies withhold/deduct taxes in UAE based on your citizenship or we get entire gross salary and we need to pay the taxes only when filing at home country if applicable?

like

Currently a C (level 2, "experienced hire", usually 2+ YOE) but with no experience prior to Deloitte. 1.5 YOE at D and up for promotion to SC in June. I'm a data scientist.
What's the realistic GS...

like

Does anyone know why Mama Mei’s at the block closed(pre-COVID). They had the all time best spicy fried chicken sandwich! Love hot lolas but Mei’s was on a different level.

like

What are the most pressing scientific questions that haven't been researched nearly enough to date?

like

Recommendations for Vienna and Budapest and other cities that would be a quick trip away?

like

Hi fishes,

Current ctc - 7lpa
Experience- 1 year.

Techstack- data science

How much I should negotiate for annual hike in current company?

like

Happy New Year, y’all TO fishies.

like

I recently left public accounting to join a start up. I don’t have too many connections in this world yet, does anyone have recommendations for either articles, books or other sources of information I could use to get an understanding of the startup world and how I can make the right career choices moving forward. - *I’m on the product manager side*

Thanks in advance!

like

How is the Salesforce marketing cloud in Nagarro ?

like

I coach artists to become full time. I feel confident in business development and sales, but any tips or resources to start learning marketing?

Additional Posts in Excel Genius

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 distribution for which answers were chosen among the top 3?

like

Workaround for a median ifs formula? I’m assuming an array but cant nail it

Does anyone use a macro recorder to record key strokes/ mouse clicks and convert it to code? Not for excel, but for programs outside excel? I’d like to automate a monthly process of running (cont)

like

Google Sheets vs Excel - pros and cons? Asking seriously.

like

Is there any big advantage of using gsheets over excel?

like

Hotkey question. Let's say I have 10 rows of data. Added a new column, want to quick fill cells. When I use Ctrl+ down, it select 10k rows because they are all blank. Any better option??

likefunny

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

I have multiple sheets with same columns that I want to combine in a single sheet within the same workbook without having to copy paste . They all have same column names and each one has a header row. How to do this ?

likesmart

Any ideas for how to reshape a dataset from wide (panel) format with two column header rows to long (pivot) format while keeping one column header row?

Post Photo
like

Please do excuse how dumbed down the example is, I’ve had to replicate the problem on a much smaller scale with all sensitive data removed.

“Location” refers to a location of stored data and “User group” refers to the user that has access to the location.

I am attempting automate the finding of all instances of where the “U1” user group occurs but exclude it if another user group also has access.
Continued below….

Post Photo
like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Is there any way to compare multiple index match formulas. Looking to find a match across three different tables on three different tabs. Most I’ve seen is using if error to compare 2.

like

Just got a new personal laptop. Is there a good way to get Microsoft Office for free? I’m looking for a download rather than the subscription usage

I’ve Paid 3 ppl who couldn’t do this for me on Fiver. I run a football Tournament. The last number is the Total points. How do I set this up where it moves it moves up or down automatically

like

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

I use both excel and google sheets, and love them both for different reasons, but they don't agree on which direction decimal rounding goes and it makes me crazy

Post Photo
likefunny

Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what 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 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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal