Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How to create new excel file with the required calculation?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-30-2018, 02:14 AM
Mangesh1212 Mangesh1212 is offline How to create new excel file with the required calculation? Windows 7 32bit How to create new excel file with the required calculation? Office 2007
Novice
How to create new excel file with the required calculation? 		 
Join Date: Nov 2018
Posts: 8
Mangesh1212 is on a distinguished road
Default How to create new excel file with the required calculation?
Hello All,



I have attached sheet and mentioned the requirement in the excel file itself.

Two sheets, the first sheet contain data format and the second sheet has the desired output required.

Many Thanks
Attached Files
File Type: xlsx Book1.xlsx (9.2 KB, 9 views)
Reply With Quote
  #2  
Old 11-30-2018, 04:56 AM
ArviLaanemets ArviLaanemets is offline How to create new excel file with the required calculation? Windows 8 How to create new excel file with the required calculation? Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
You found a way to make calculations as difficult as possible

Maybe attached will work better?
Attached Files
File Type: xlsx TickAndNick.xlsx (12.2 KB, 9 views)
Reply With Quote
  #3  
Old 11-30-2018, 05:16 AM
ArviLaanemets ArviLaanemets is offline How to create new excel file with the required calculation? Windows 8 How to create new excel file with the required calculation? Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
An another way based on Sheet3 is a Pivot Table
Attached Files
File Type: xlsx TickAndNick.xlsx (16.1 KB, 12 views)
Reply With Quote
  #4  
Old 11-30-2018, 06:11 AM
Mangesh1212 Mangesh1212 is offline How to create new excel file with the required calculation? Windows 7 32bit How to create new excel file with the required calculation? Office 2007
Novice
How to create new excel file with the required calculation? 		 
Join Date: Nov 2018
Posts: 8
Mangesh1212 is on a distinguished road
Default
Thanks ArviLaanemets. I understood the approached suggested by you.

:-)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create microsoft Excel 2007 and 2010 File in .xlsx format ipacesetters Excel 1 12-16-2019 05:13 PM
How to create new excel file with the required calculation? Excel formula problem/ Help required dmcg9760 Excel 5 09-10-2015 09:42 PM
2010 VBA prevent calculation when file is opened. Phil Payne Project 5 02-23-2015 07:48 AM
How to create new excel file with the required calculation? Help required with Selection.Find to search a text file. Marko Word VBA 2 10-18-2014 06:32 AM
How to create new excel file with the required calculation? Open document file location issue help required jborchel Word 8 10-21-2013 02:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft