Forum

Miguel Calejo
@canetas
Eminent Member
Joined: May 27, 2014
Topics: 8 / Replies: 7
Reply
RE: Consolidate Two Pivot Tables Reports

One Column with all Agents (Buyers and Sellers) the solution. Thanks Anders

2 years ago
Reply
RE: Consolidate Two Pivot Tables Reports

Thanks, Mynda, for your help. There are some conditions that I didn’t express at first hand. This is for a Real Estate Business: For the sa...

2 years ago
Topic
Reply
RE: Column with different type of values

Thanks Velouria for your help it was very useful, here's what hapened: a) With the formula Value.Is([field name], type datetime) it returned F...

4 years ago
Forum
Topic
Forum
Replies: 3
Views: 71
Reply
RE: Currency with decimal comma or point

HI Philip, Every month I need to download csv files from Amazon Spain (my company is portuguese but sells in Spain, Italy and France, windows 10 i...

5 years ago
Forum
Topic
Forum
Replies: 3
Views: 161
Reply
RE: Change Data Format to Decimal Number

Thanks Mynda, That was the problem; I'm portuguese and my Windows 10 is in portuguese and the Power BI is also in portuguese, so the decimal d...

5 years ago
Forum
Topic
Forum
Replies: 2
Views: 288
Reply
RE: VLOOKUP with CHOOSE function keeps delivering #N/A Error

Thanks for your approach, I'm runnig Excel 16 in english, but in Windows 10 in portuguese, and the argumenst in Excel are separated by a semicolon(...

5 years ago
Topic
Replies: 1
Views: 48
Reply
RE: Custom Number Format - Scaling a number

(The custom format between the quotes) Format "#,#.K" turns 7200 to 7,2K and the point is to turn to 7.2K Format "#.#,K" turns 7200 to 7.200,K ...

7 years ago