Forum

Alan Sidman
Alan Sidman
@alansidman
Moderator
Member
Joined: Oct 18, 2018
Last seen: Jul 30, 2025
Topics: 3 / Replies: 232
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?

6 months ago
Forum
Reply
Reply
RE: Spreadsheet Compare Output

also crossposted at: /p> and

6 months ago
Reply
RE: STOCKHISTORY not working

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

7 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. ...

7 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...

9 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.

11 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"...

1 year ago
Forum
Reply
1 year 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.

1 year ago
Forum
Reply
RE: Reconciliation -data is in two columns

crossposted: Suggest you read:

1 year ago
Forum
Reply
RE: IF Ranges

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

1 year 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...

1 year ago
Page 3 / 16