ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   consolidate (https://www.excelbanter.com/excel-discussion-misc-queries/89021-consolidate.html)

Consolidt

consolidate
 
hello and how are you dear sir:
hope you will be ok my question is that please tell me how i can
use the "consolidate" command in data manue so if you give me answer i will
very thankful to you
best regards
Samiullah "Maqsodi"

Dominic LeVasseur

consolidate
 
Samiullah,

What are you trying to accomplish?

As far as I know, the Consolidate function will group data together from
different ranges. It will perform a particular function/operation that you
specify on that data.

PivotTables are able to do many of the same things and are more powerful and
easier to use.

I would suggest PivotTables unless you are unable to use them for some reason.

Hope that helps.





"Consolidt" wrote:

hello and how are you dear sir:
hope you will be ok my question is that please tell me how i can
use the "consolidate" command in data manue so if you give me answer i will
very thankful to you
best regards
Samiullah "Maqsodi"



All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com