Forum

Alan Sidman
Alan Sidman
@alansidman
Moderator
Member
Joined: Oct 18, 2018
Last seen: Jun 4, 2026
Topics: 3 / Replies: 263
Reply
RE: INDIRECT TAB YEAR alternative for 3D ARRAY? + #REF! avoid

crossposted: /p>   Please open this link and read-->/p>

6 months ago
Reply
RE: Income stmt using power pivot

Probably yes, but it would be more helpful if you posted in a file a sample (10-15 records) and then mock up what you want the results to look like. ...

7 months ago
Forum
Reply
RE: DSUM

Here is a tutorial on DSUM  

7 months ago
Reply
RE: Weekend Rotation Work Schedule

Suggest you post a file that is representative (anonymized) of your actual file. Then mock up a possible solution (or explain specifically the expect...

7 months ago
Reply
RE: Help - used get data in a csv file - referencing itself - to transform in Powerquery - created pivot tables - didn't save?

Suggest you upload your file with your Mcode for analysis with an explanation as what specifically you are attempting.

7 months ago
Reply
RE: List update

Please attach sample files which do not include confidential/personal information. Mock it up with fake info if this applies. Post a file with 8-12 ...

7 months ago
Reply
RE: Unique ID# generator for a column that will follow column sorts

You could copy and Paste Values after entry. That does seem like a bit of work in my mind, but it will preserve the value if you then do any sorting.

7 months ago
Reply
RE: Running Total showing only negatieve figures

While you have given us a title and a sample workbook, you have not described your objective. Please tell specifically what you are attempting. No f...

7 months ago
Forum
Reply
RE: Sending emails to team members when certain options are selected in an excel file

Without sample data, then perhaps you could filter your spreadsheet and email the filtered results. Rinse and Repeat.

7 months ago
Forum
Reply
RE: TextSplit

Since you have three columns of data, please mock up how you would like the result to look like. I want to be sure we supply the right answer before ...

8 months ago
Forum
Reply
RE: Create an Order summary

Where are the survey results. They are not apparent in the information/file you have provided.

9 months ago
Forum
Reply
RE: Monthly Transaction Tracking System

You should be able to attach xlsx, xlsb and xls file without issue. Check the size as that may be an issue. You can also zip a file. Is your file c...

9 months ago
Reply
RE: Conditional formatting using named range

Did you read this when you signed up to participate in this forum? If not, suggest you do so now.

10 months ago
Reply
RE: Conditional formatting using named range

What file type are you trying to attach?

10 months ago
Page 2 / 18
0