Forum

SunnyKow
@sunnykow
Noble Member
Joined: Jun 25, 2016
Topics: 0 / Replies: 1417
Reply
RE: Actual vs Budget-Depending on the Month selection, Sum Rows from different sheets.

Hi Kim See if this is what you wanted. It is a bit difficult to come up with the solution as you did not give us the file with all the required ...

7 years ago
Reply
RE: Automatic Serial number generation

Hi Mohamed Give this a try. Please note that it will always increase the serial number in cell J3 before it prints. So if you are printing fo...

7 years ago
Reply
RE: Duplicate items within projects

Hi Mohamed See if this is what you wanted. Sunny

7 years ago
Reply
RE: Automatic Serial number generation

Hi Mohamed There are 2 items in your worksheet. Are you printing them both at once or one by one? Are you selecting them if you are printing ...

7 years ago
Reply
RE: Pivot Chart; unable to format axis

Hi Adriane If you are referring to the Pie chart then right-click the data labels. Under Label Options click Reset Label Text You can also re...

7 years ago
Reply
RE: Pivot Chart; unable to format axis

Hi Adriane There is no attachment.

7 years ago
Reply
Reply
RE: Continuity Expression in Excel

Hi Sheikh This is as close as I can get to what you wanted. It uses an ARRAY formula so you must finish with CTRL+SHIFT+ENTER instead of ENTER w...

7 years ago
Reply
RE: Codes and their Sums

Thanks for your feed back. Glad we could help. Use whichever method you feel comfortable with as long as you achieve your objective.

7 years ago
Reply
RE: Banding the cells of black color with the Max section

Glad we could help Thanks for your feedback.

7 years ago
Forum
Reply
RE: require a formula

Please attach an Excel workbook with your sample data and the expected result.

7 years ago
Reply
RE: Continuity Expression in Excel

Hi Sheikh Misbah Please attach a sample file containing your original data (without your formulas) and then the expected result (highlight them) ...

7 years ago
Reply
RE: Banding the cells of black color with the Max section

Hi Maurizio From my understanding, you want to add some data in a range and then draw thick borders around the newly added data. Hope I am corre...

7 years ago
Forum
Reply
RE: Codes and their Sums

Hi Please refer attachment. You can use a formula or a Pivot Table. Hope this helps. Sunny

7 years ago
Page 45 / 95