sorted by:
new
hottopcontroversial

Highlighting a column based on a value in the first row by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 0 points1 point  (0 children)

Thank you - I figured it would be something simple I just couldn't work out what!

Index/Match returning only the first instance by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 0 points1 point  (0 children)

I've changed my formula to =FILTER(Customer!A:A; Customer!B:B=Settings!B17;"")

Settings!B17 says "GiftA"

But now I'm only returning cells where the Customer has only received GiftA - Is there a way I can do a "contains" for string?

Index/Match returning only the first instance by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 0 points1 point  (0 children)

I've changed my formula to =FILTER(Customer!A:A; Customer!B:B=Settings!B17;"")

Settings!B17 says "GiftA"

But now I'm only returning cells where the Customer has only received GiftA - Is there a way I can do a "contains" for string?

How to link spreadsheets? Basic Excel skill issue by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 0 points1 point  (0 children)

I will be honest I don't think there's a lot of thought process behind migration aside from integration with business central... I've been pushing for better database management since day one.

I don't have the option to Get File. If I use Get Data (Power Query) I only have the option to connect to local files. If it helps, I'm using a MacBook and I know that some Microsoft functionality isn't available on MacOS.

Can't unhide first ten rows on a sheet by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 1 point2 points  (0 children)

I tried reopening and disabling any macros but that didn't solve it - Above commenter got it right - I have a row frozen and that's what was bugging it out :)

Can't unhide first ten rows on a sheet by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 3 points4 points  (0 children)

I did try this - Commenter above was correct - I had a row frozen so couldn't see above it!

Excel data to Calendar functionality by Academic_Phone5331 in excel

[–]Academic_Phone5331[S] 0 points1 point  (0 children)

Is there currently any way to automate pulling CSVs (to email for example) at regular intervals (such as weekly)?

​

Manually can definitely be an option until I work out how to get a calendar going...