Excel Help and Problems

[jackofall]

Excel has a great Pivot Chart feature built in. Should be exactly what you're looking for.

Thanks, no idea why I never saw the pivot chart option.

[yesitsme]

Thanks, no idea why I never saw the pivot chart option.

Live & Learn

[jackofall]

Is there a way to paste a formula into multiple cells that already have data. For Example - A1:A120 has random numbers in each cell I want to add a formula to each cell in addition to the number in the cell currently.
TIA

[MarkS]

Is there a way to paste a formula into multiple cells that already have data. For Example - A1:A120 has random numbers in each cell I want to add a formula to each cell in addition to the number in the cell currently.
TIA

Say your formula is 1+1. In B1 enter =A1+1+1 and drag down

[jackofall]

Say your formula is 1+1. In B1 enter =A1+1+1 and drag down

Thanks

[PTU]

Have a table, columns are the names and rows are months.

How can I convert this to a list where that will have all the months in column A and the name in B? So it will list

Jan

sam

transaction

Jan

jack

transaction

feb chaim transaction

feb

shemerel

transaction

[skyguy918]

Have a table, columns are the names and rows are months.

How can I convert this to a list where that will have all the months in column A and the name in B? So it will list

Jan

sam

transaction

Jan

jack

transaction

feb chaim transaction

feb

shemerel

transaction

Easiest thing to do would be to create the first 2 columns yourself by copy and pasting, then use INDEX/MATCH in the 3rd column to pull in the transaction for each combination.

[AJK]

How would I sort a pivot table by criteria that is not in the pivot table itself, but IS in the source data?

Looking to sort first column by date, but date is not included in pivot table, but it in source data.

[shoobi]

Try adding it to the pivot table in a non-altering way? i.e. add the date field to the "filter" section of the pivot table and keep it selected to "all"

ETA: yeah doesn't seem like a solution

[AJK]

Try adding it to the pivot table in a non-altering way? i.e. add the date field to the "filter" section of the pivot table and keep it selected to "all"

Filter would only do that, "filter."

I need it sorted by a date that's present in the source data.

From my searching, I'm not sure it can be done.

[EJB]

Filter would only do that, "filter."

I need it sorted by a date that's present in the source data.

From my searching, I'm not sure it can be done.

Don't think it's possible without VBA or presorting data, unless you are ok adding a hidden or invisible column.

[AJK]

That's what I figured.

What do you mean by presorting data or adding hidden column?

[Ergel]

That's what I figured.

What do you mean by presorting data or adding hidden column?

Presorting data, he means sorting the source table
Hidden column would mean adding an extra column with the date in your pivot table and sorting based on that. However, being that the column is not present in your pivot table, he assumes that you don't want to display the date in your pivot table. As such, he is recommending hiding that column.

[PTU]

That's what I figured.

What do you mean by presorting data or adding hidden column?

You should be able to sort pivot tbl by source data. Maybe right click and see if the option is there

[yesitsme]

Does anyone Here know the "Solver" Password?

[jackofall]

To confirm. If I have a sheet with rows of info for ex. A name b address c transaction date etc. if I select all the data and hit remove duplicates it will only remove a row if all the data in the row matches to another row, is this correct?

[bubbles]

To confirm. If I have a sheet with rows of info for ex. A name b address c transaction date etc. if I select all the data and hit remove duplicates it will only remove a row if all the data in the row matches to another row, is this correct?

It will give you the option to choose which columns need to match to be considered duplicates. Default is that all the columns need to match, like you are saying.

[jackofall]

It will give you the option to choose which columns need to match to be considered duplicates. Default is that all the columns need to match, like you are saying.

Thanks.

[yesitsme]

To create a sheet for each month in VBA

Code: [Select]

Sub createbooks()
Dim x As Integer
Dim i As Integer
 
For i = 1 To 11
If i = ActiveWorkbook.Sheets.Count Then
     ActiveWorkbook.Sheets.Add
    End If
Next
 
For x = 1 To ActiveWorkbook.Sheets.Count
   Sheets(x).Name = MonthName(x)
Next
End Sub


[PTU]

To confirm. If I have a sheet with rows of info for ex. A name b address c transaction date etc. if I select all the data and hit remove duplicates it will only remove a row if all the data in the row matches to another row, is this correct?

When in doubt, always do your work on a duplicate tab. Always.