How can I gather data from the internet into one spreadsheet? For example: I want the color, height and bloom season of certain rose types in my spreadsheet.

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

Power BI

like

I need to learn power BI for sure. Thanks for the suggestion ! Might have to YouTube

And python

likesmart

I’m def not familiar with Python. But will be looking into it. Thanks!!

Great question. I’d love to know how to get like Alteryx or excel to pull specific data like that from the internet without having to feed it the data needed in the first place.

like

I don’t know which data source you have. But I really love Power Query function already included in excel. Look it up. It’s very useful

like

Related Posts

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

What ICOs are you guys looking into? Hoping to research some

like

I have received 3 offers from 3 companies for PM role in the last week with my preferred company offering the least.

I would like to negotiate based on competing offer numbers - what are the things that I should keep in mind when doing so? Anything that I should be of? Like should or should I not share the actual offer letter? Etc?

Not sure if this matters but I have a total of 14YOE with 5 of them in a BA, Sr. BA roles. Started off as a software engineer.

like

How much are the AC and C level getting paid at Slalom Canada?

like

Could anyone suggest a good ladies pg in Marathalli area? Preferably single sharing or double.

like
like

Guys I got an offer for Deloitte CBO AMI AMM entity. Anyone aware of this group, work hours, scope of work. Is it worth considering?

Hi, What is the max pay for Senior Consultant role C1 band?

like
like

Hi all,

I got offer from below company please provide your suggestions which one is good. All are offering same Salary.

Java backend developer
1. Coforge (client -HSBC )
2. HCL (client - Conduent)
3. Ezetap by Razorpay
4. E-zest solution
5. Algoworks
6. Egencia by amex

like

I’m really liking DMZ mode in Warzone. I think they have some real potential with this game mode. I like that it’s not as sweaty as Tarkov but still has some elements of it. Still in beta but I hope they realize they have a potential gem here.

like

Is it worth moving to Germany for 60,000 euros per annum job from a BIG4 with 16LPA INR ? I'm single not married yet.

like

Will GYMPASS be an additional benefit on top of the $500 EY wellness benefit? What is it?

likehelpful

Anyone hiring an ACD? I may be relocating here ‘cause my wife is accepting a position at Target. How many agencies are there?

like

Quit my cushy job a few months ago because I was totally burnt out and mental health was shot. Thinking about quitting this industry all together - anyone else go through similar? Any advice? Thanks!

like

What is 'Customer Success Team BU' in LTI? Does anyone have any background?

like

I got an offer from LTI for Senior Software Engineer Role with P2 grade in Banking and Financial Services BU.
3.9 YOE
Tec Stack : Java, Spring, springboot.
How will the WLB, culture , leaves , work , hikes be in LTI?
Note : I have an offer from People Tech Group for Amazon client for similar pay.

like

How much time does LTI takes to release offer letter?
I had my documents submission and final hr round on 26th oct
YOE :12yrs
Please help fishes

like

Is it possible to get a convenient location transfer in LTIMindtree? Or it can be decided only after the project allocation?

like

Additional Posts in Excel Genius

What are your top Excel ninja tricks? Ones that few people know...

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anyone know what these badges are?

Post Photo
likefunny

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Still don't have xlookup. #fomo

like

Would anyone be willing to teach me vlookup?

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How do I compare two sheets to make sure they are identical?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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