• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HELP REQUIRED FOR ANALYZING DATA

damorashish

New Member
Dear All,

I am new to this forum. I have data as per enclosed table but it is not as per the required format. Please help me get some formula so the data can be arranged as per required order for analyzing. I will be highly obliged. Sample DATA TABLE AND REQUIRED FORMAT enclosed.
 

Attachments

Luke M

Excel Ninja
Welcome to the forum!

Your attached file is hard to understand as it only has one sheet with info. Is that in the desired output, or how the input looks? It currently looks like the layout of a PivotTable. Please clarify what you have vs. what you want.
 

bosco_yip

Excel Ninja
Your enclosed file does not content "Required Format",

please re-upload your file to show what do you wanted format.

Regards
Bosco
 

GraH - Guido

Well-Known Member
Did you check if
- the data is structured in the same way in both files -> if not the formula may refer to the wrong columns, thus it is not working.
- with the copy you are actually referring the the workbook you've copied from?

Perhaps copy formula in the cell (F2, CTRL+A , CTRL+C) and then past in the new file.
 

deciog

Active Member
Bosco Good Morning.

When I undo the merge, it appears in the cell = A2 ... = A14, very interesting, but when I do in my Excel version 385 2016, it in the merge leaves only the first cell or A2, so I ask, how does this trick ?.

Thank you Decicio
 

damorashish

New Member
Bosco Good Morning.

When I undo the merge, it appears in the cell = A2 ... = A14, very interesting, but when I do in my Excel version 385 2016, it in the merge leaves only the first cell or A2, so I ask, how does this trick ?.

Thank you Decicio
Dear Bosco,

I am also facing same problem. Please explain
 

damorashish

New Member
Dear Bosco,

Sorry to bother you once again. Please find my excel enclosed. In this file if the concerned department is mentioned in first row then the answer will come as per formula but for other department it does not come. There is very long list of agents and I have to copy agent name in each row for getting correct answer. Please help
 

Attachments

bosco_yip

Excel Ninja
Dear Bosco,

Sorry to bother you once again. Please find my excel enclosed. In this file if the concerned department is mentioned in first row then the answer will come as per formula but for other department it does not come. There is very long list of agents and I have to copy agent name in each row for getting correct answer. Please help
The trick to fill range A2:B25 blank cells with data

1] Copy A2:B25 format and Paste to unused range T2:U25

2] Select A2:A25 >> Unmerge cells of A2:A25 >> press "F5" >> click "Special " >> click "Blank" >> OK >> enter: =A2 >> press Ctrl+Enter

3] Copy T2:U25 format and Paste back to A2:B25 >> delete column T and column U >> Finish


Then, the Sumifs formula will return the desired result

Regards
Bosco
 

Attachments

damorashish

New Member
The trick to fill range A2:B25 blank cells with data

1] Copy A2:B25 format and Paste to unused range T2:U25

2] Select A2:A25 >> Unmerge cells of A2:A25 >> press "F5" >> click "Special " >> click "Blank" >> OK >> enter: =A2 >> press Ctrl+Enter

3] Copy T2:U25 format and Paste back to A2:B25 >> delete column T and column U >> Finish


Then, the Sumifs formula will return the desired result

Regards
Bosco
Dear Bosco,

Thanks again.
 
Top