Forum

Alan Sidman
Alan Sidman
@alansidman
Moderator
Member
Joined: Oct 18, 2018
Last seen: Apr 20, 2025
Topics: 3 / Replies: 217
Reply
RE: Slicer is not working!!!

Slicer is working in the attached. Not sure of your issue. Inserted slicer based upon Name. Am I missing something?

3 months ago
Forum
Reply
Reply
RE: Spreadsheet Compare Output

also crossposted at: /p> and

3 months ago
Reply
RE: STOCKHISTORY not working

MS has issued an update (2502) and Data Type has been restored as well as StockHistory.

3 months ago
Reply
RE: STOCKHISTORY not working

I noticed this yesterday also. Additionally, I noticed that Data Types are no longer on the Data Ribbon. I am using O365 Beta Insider release 2501. ...

3 months ago
Reply
RE: Display related data when item selected

Suggest you attach a file that shows sample data that is representative of your actual file. Then mock up your expected results so that we understand...

6 months ago
Forum
Reply
RE: Scrape Date from Multiple Web Pages

The print in your picture is too small to read. You would be better served attaching your workbook for analysis.

7 months ago
Forum
Reply
Reply
RE: Replace values that contain a quotation mark

This worked for me. let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Replaced Value" = Table.ReplaceValue(Source,"Notebook 5"...

9 months ago
Forum
Reply
9 months ago
Forum
Reply
RE: Complex, name-dependent transposition

One approach I took was to create a pivot table in Power Pivot. Create a measure to group the unit codes and unit names.

10 months ago
Forum
Reply
RE: Reconciliation -data is in two columns

crossposted: Suggest you read:

10 months ago
Forum
Reply
RE: IF Ranges

Cannot manipulate data in a picture. Please reattach a sample file with mocked up expectations.

10 months ago
Reply
RE: Calculated item for 2 levels of data in my pivot table

Sample data would be very helpful to providing you with a solution. Updates some sample data and a mocked up solution so that we know exactly what yo...

11 months ago
Page 2 / 15