The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
HOW TO ATTACH YOUR SAMPLE WORKBOOK:Unregistered, Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: piviot tables

Search: Replies Views Search took 0.00 seconds.

error message. How to get rid of the message?

Started by ThomasB61‎, 08-20-2024 09:04 AM
- 11
- 289
Last Post By:

Last Post: 08-22-2024 09:59 AM

by romperstomper

Forum:
Excel Programming / VBA / Macros
[SOLVED] Use a Pivot table to work out average order value of invoices

Started by Melissa_8‎, 05-17-2024 09:11 AM
- 3
- 330
Last Post By:

Last Post: 05-17-2024 09:28 AM

by AliGW

Forum:
Excel Charting & Pivots
How to properly sort row labels data if it has date?

Started by 0Cool‎, 02-08-2022 01:35 AM
- 1
- 641
Last Post By:

Last Post: 02-08-2022 03:40 AM

by TMS

Forum:
Excel Charting & Pivots
Splitting a pivot table into two

Started by JRDavie‎, 07-19-2021 07:45 AM
- 6
- 2,580
Last Post By:

Last Post: 07-23-2021 10:36 AM

by JeteMc

Forum:
Excel General
Combining Data advice

Started by Crawfy‎, 04-26-2021 02:19 AM
- 1
- 1,031
Last Post By:

Last Post: 04-26-2021 02:47 AM

by hrlngrv

Forum:
Excel General
[SOLVED] Cell does not react to formatting

Started by pkobzar‎, 01-30-2020 06:32 PM
- 1
- 983
Last Post By:

Last Post: 01-31-2020 12:58 AM

by FDibbins

Forum:
Excel Charting & Pivots
Formulas to make my spreadsheet better

Started by Abbylea‎, 01-18-2018 08:10 AM
- 5
- 840
Last Post By:

Last Post: 01-18-2018 03:52 PM

by sandy666

Forum:
Excel General
Multiple Repeating Names with Date

Started by Swalrath‎, 06-29-2017 04:22 PM
- 2
- 647
Last Post By:

Last Post: 06-29-2017 07:26 PM

by sandy666

Forum:
Excel Charting & Pivots
Using Pivot Charts to count names

Started by B_Jarbs‎, 02-25-2016 05:08 PM
- 5
- 866
Last Post By:

Last Post: 02-28-2016 11:28 PM

by NeedForExcel

Forum:
Excel General
Finding unused Pivot Tables

Started by scottc_00‎, 08-12-2015 12:57 PM
- 0
- 393
Last Post By:

Last Post: 08-12-2015 12:57 PM

by scottc_00

Forum:
Excel Programming / VBA / Macros
i am not able to sum in pivot table

Started by vishnulakhani‎, 07-22-2015 07:09 AM
- 1
- 398
Last Post By:

Last Post: 07-22-2015 07:10 AM

by arlu1201

Forum:
Hello..Introduce yourself
Piviot Table Calculating incorrect

Started by lpulgar00‎, 06-24-2015 10:41 PM
- 1
- 837
Last Post By:

Last Post: 06-25-2015 02:13 AM

by cbatrody

Forum:
Excel Charting & Pivots
Cross reference 2 lists. Count matches on 2 lists. WHat feature to use?

Started by islesnyanks88‎, 07-27-2014 09:40 AM
- 1
- 1,149
Last Post By:

Last Post: 07-27-2014 10:23 AM

by newdoverman

Forum:
Excel General
Creating an attendance tracker, Help

Started by jsquarity‎, 06-25-2014 02:08 AM
- 1
- 1,228
Last Post By:

Last Post: 06-25-2014 12:01 PM

by jsquarity

Forum:
Excel Formulas & Functions
Merged Cells when creating Tables.

Started by V1gilante‎, 01-22-2014 02:35 AM
- 2
- 1,548
Last Post By:

Last Post: 01-22-2014 02:44 AM

by V1gilante

Forum:
Excel Charting & Pivots
Group scores based on value in first column

Started by jlm099‎, 04-25-2013 02:40 PM
- 7
- 1,189
Last Post By:

Last Post: 04-25-2013 05:31 PM

by jlm099

Forum:
Excel General
Chart to show different status of customer in company system

Started by applesandpears‎, 01-25-2013 06:36 AM
- 0
- 1,102
Last Post By:

Last Post: 01-25-2013 06:36 AM

by applesandpears

Forum:
Excel Charting & Pivots
Calculate orders past agreed dates in pivot table and averages in pivot tables

Started by applesandpears‎, 10-17-2012 06:00 PM
- 17
- 2,616
Last Post By:

Last Post: 10-18-2012 05:26 PM

by djapigo

Forum:
Excel Formulas & Functions
data layout for charts

Started by muecyl‎, 05-24-2011 08:36 PM
- 1
- 860
Last Post By:

Last Post: 05-24-2011 10:18 PM

by teylyn

Forum:
Excel General

Results 1 to 19 of 19

Search: Replies Views Search took 0.00 seconds.

[SOLVED] Use a Pivot table to work out average order value of invoices

[SOLVED] Cell does not react to formatting