{ "_id": "5a56f68d15f6ef0013aad256", "_isBlocked": false, "creationDate": "2018-01-11T05:30:53.591Z", "categories": [], "description": "Discussions, Useful Tips, Resources, Macros, More", "relatedCrowdIds": [ "552d1d24dc1c586b09d2d051", "55375ce690f5eebe1d2a0f88", "5c751b9f2f6b98001bc666f8", "564a5cdb94887803001dd07c", "5565cfca8b2b9a03009acf57", "553769a790f5eebe1d2a0f92", "5787dd60a3f35c130082b851", "552d1d24dc1c586b09d2d052", "5682e6afd55b9e0f00fce669", "5e77c585cba148001ab93ed9", "5d0a757f66884500200aff25", "56c75c3c1dc12b0a0097ccb0", "56fd40e29238700e00b5ee4a", "575591bd4715870e00d30511", "5e8d00ee065ee5002135bc2f", "5ef17d0fc9914f0024fe1911", "6307b985e8cea3002c9297b4", "63079a6ca12e86002600a26a", "5e7169c6c917a6001ba5fefc", "63079f67548aa90022fc0415", "564cbaf767469503004fede0", "5e4bca4d473da1001b53cb24", "5eb1bcb23b975f0021424ca1" ], "fishIconColor": "4c28ff", "hideNumberOfUsers": false, "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/zyKRUmCcr4SD4.png", "rectangleIconUrl": "", "isLocked": false, "isCommentsEnabled": false, "isPublic": false, "handleUrl": "excel-genius", "isVisible": true, "name": "Excel Genius", "networkingEnabled": false, "numberOfNetworkingUsers": 488, "numberOfUsers": 119124, "type": 2, "creatorId": "5a328e7245ae9f00180fa77e", "bowlType": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise", "divisions": [], "feedState": { "lastMessage": "Basically, I have a data set with the following columns: “State - city - person name - office number” and I’m using index match to pull the office number based on the selection that I make for person name. My issue is that there are duplicate names in the person name column. So when I select the state, city, and person name, the index match formula for office number is pulling the first matching name it finds in the list. How can I make the index match formula search for the office number based", "lastSign": "Senior Consultant", "lastUpdateDate": "2022-10-04T19:06:22.954Z", "lastMessageDate": "2022-10-04T19:06:22.954Z", "countOfSystemMessages": 0, "countOfUserMessages": 1620, "countOfMessages": 1605 }, "background": { "from": "05B3DF", "to": "0F71A6" }, "priority": 0, "numberOfFollowers": 44546, "promptsDisabled": true, "roomEnabled": false, "regions": [ "61891c8e2ca26eaffdf8d90f" ], "requestToJoinSettings": { "isJoinReasonRequired": false, "shouldRequestPhoto": false, "isMultipleChoiceEnabled": false }, "bowlTypes": [ { "bowlTypeId": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise" } ], "suggestedIndustry": { "_id": "552d1d24dc1c586b09d2d051", "name": "Consulting", "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/q6ousBABT88sI.png", "crowdIconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/KF6SyAmqgD6Ae.png" }, "noIndex": false, "lastView": "" }

Basically, I have a data set with the following columns: “State - city - person name - office number” and I’m using index match to pull the office number based on the selection that I make for person … more

like

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context: more

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, a… more

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
like

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

like

I am probably over complicating this which is why I can’t figure out the best formula, but I am trying to return a set value (column D) if a date falls within the date range from columns A and B. Basically I want to be able to type in any date and if that date falls within one of the ranges to give me only the value for that row from column D. I thought an IF(AND) nested in VLOOKUP would work, but I can’t get it to work. Any advice?

Post Photo
like

Need help with a formula. I’m downloading bank statements to excel and I’m trying to do a lookup so it fills in the category based on the bank description. The problem is I’m trying to use the entire … more

like

Excel geniuses, is there a template one can use to have numbers in excel output in ppt? Looking to build some basic daily operational dashboard? TIA

like

I want to learn and master all the tricks in MS Excel

like

I would like to shortcut the time of filterating the data by creating a template to extract the data wanted into different tabs every time I copy paste a new data.? Any idea?

I work as an a… more

like

Hello Excel Genius!
How do I calculate the monthly average of items returned and credit return by each division in a year?
Thank you!

like

How can I make my pivot show the column values as a count? I select all columns and select show as count but it only changes one column...

Does anyone have any strong feelings about using QueryEditor in financial models? I am working on a financial model and one of the team has suggested using QueryEditor to wrangle some data (de pivotin… more

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Minitab or Excel?

Hello hello.

I have a column of dates in the format of mm/dd/yyyy

How do I count how many dates occured after the 15th day of their respective months (e.g. Jan 16, 2022 is count… more

like
Share this 🔥 post

Hey all, what’s the VBA code where I fir every instance 1 is found in column D, input i +1 else just put I.

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
like

Anyone know how to keep color headers on a excel from changing in a pivot table when changing filters? As soon as I change filters all column headers change and I have the check box to “preserve cell … more

like

Hello for some reason I can’t get my value filters to work to filter sales greater than 0 in a pivot table as seen below. Every time I try to apply it, nothing happens. I tried to filter GM and GM % but no luck as well. Any idea?

Post Photo
like

Hi! Anyone have any really good excel courses , i like to think im good with keyboard shortcuts. But other things I could use a big boost in.

like

Hello. Does anyone know how to redact some cells in excel spreadsheet without the need to use macro or any other software? Thank you all in advance!

like

Alright, I feel this may be a rudimentary question. I created a simple macro to have a listbox show all tabs in a workbook. How do I transfer this to coworkers? I have it in my personal workbook which… more

like

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after tra… more

like

Excel geniuses, what are some recommended excel certificates or good enough programs to consider? No specific length 🙏

like

I need help. I'm trying to split cells in a mailing list. I've been able to do this by using the text to columns wizard. However, within the list there are multiple residents that have two people living together with different last names. This has caused an issue for me that I have included a picture of. The only way I would know to fix this would be to do it manually. Do any of you know of a way to do this without fixing each individually?

Post Photo
like

I have a large list of names and locations that I need to creat drop down lists for. I need the drop downs to be dependent on another since there are duplicate names. E.g. when I select John Doe, I wa… more

like

Alt + H + FP + (Directional Arrow) = Format Painter for the cell you moved toward in the directional arrow…

Here is what I want to know… how can I paste this format painter to MULTIPLE cell… more

like
Share this 🔥 post

Hello Magic Fingers, Looking for your quick suggestions - how to deal with the Trace errors? I am getting trace errors on certain cells whenever I download any datasets out of JDE. For example if an … more

like

Hey all, for VBA what would the code be for searching for a specific value in column A and once that value is found go to the next row, do a loop that basically copies and pasted that value into Colum… more

like

Not necessarily Excel related, BUT I work for a logistics company and am trying to create/launch a shared customer app. In my mind, this page/dashboard would pop out issues the customer needs to focus… more

like

Problem I was wrestling with for a while today, anyone have a better solution? Need a lookup formula that has an indicator if there were multiple possible matches.
=if(countif(range,criteria)>… more

like

Looking to increase my Excel knowledge. Any recommendations on courses? Looking for intermediate-friendly content.

like

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

like

There are a lot of recommendations for Excel plug-ins for Excel but they are almost all for the Windows version, so what recommendations for plugins are there for the Mac version?

like

Is anyone on here a google sheets expert? I’m so stuck on this one thing and I can’t believe I can’t figure it out.

like

Need some excel help. I have a report that includes data for a bunch of accounts. However the report does not include a column for client name for each account. I'm waiting on our software enginee… more

like

Hi Excel people! Do you use index(match) or vlookup? What are the benefits of one or the other? When did you transition from one to the other?

like
Share this 🔥 post
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

Sign up for free to join this community 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 and Privacy Policy.
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal