Have revenue distributed between two years. How to calculate the carryover revenue with given start date of the project assuming project affected for 12 months
Start date = 03/08/2017(MM/DD/YYYY format)
End date = DATE(YEAR(Start),MONTH(Start)+11,1)
Gross Savings = 12000
Monthly savings = Gross...
hi,
I tried achieving this using data validation...but not succeded.
The requirement: $I$7 is the sum of $E$7 to $H$1
whatever the number we type in the range E7 & H1 should not exceed $I$7,if it exceeds it should give a error message.
Similarly $E$10 is the sum of $E$7 to $E$9. In this also the...
Dear Experts,
In the attached table, i need to make data validation using macros. Fonts in RED color are the sum of rows and columns.
Requirement: whenever the inout is given in that particualr column or row the sume should not exceed the corresponding value in both rows and columns. If it...
Dear Experts,
All my excle files have been corrupted and unable to open any of them.
I tried couple of free download for excel file recovery in google but non of them helped me.
Your file is severey damamged unable to recover is the message i am getting.
Please help me....as they are some...
Dear Experts,
i have issue with date. i need to change the date format from 21-08-13
to 7/8/2013. When i apply format only few of them are changing and most of them are not changing the original format.
Both the foramt are in DAte format need to change them to MM/DD/YYYY.
i tried changing...
Hi All...
I am trying to take the difference between two days which is in the format of mm/dd/yyyy hh:mm:ss ie., between two time stamp 2/29/2012 12:11:23 AM & 9/11/2012 3:14:20 PM. I know only Hour formula but breaking my head to solve this using formula...
could you please help me on...
i am curious to know the excel survey result that you took few weeks back...
is it published...Did i missed it?
if so, Help me with the link ....
Dee...
Hi Nagesh,
Conditional format to pivot is same as that of conditional format you do for any table or cell.Give a try it should come else..we are here to help...
Dee...
Dear All,
This is a query on one of the Lukes's post in Chandoo.org (Formula Forensics No. 003 – Lukes Reward).
Here in the specified formula we can have only one condition can be fulfilled ie., in the below example it is cell D2. what if i need to add more that one condition say <2 ...
Dear All,
I need to generate serial number in the summary sheet.
I have a summary sheet and a template (hidden). Macro is written to create copy of template and has to pick few details from the newly created idea template to the summary sheet.Till here its working fine. once it copies details...
Sorry, i missed sending the link...
IF this didnt work you need to suggest where i can upload the files
http://www.filefactory.com/file/complete.php/75wrdg86f43f/1enno21frex9/
Dee...
Dear All,
Enjoyed reading your postings...but disappointed for not getting the answer for the problem.
SirJB7,
For your query...
Yes, all the tables in all docs have the same structure (number of rows & cols)each of the Yes, all 9 tables have the same structure along all docs
Dear All,
I have around 20 word documents and each containing 9 tables. I want to copy all tables from all files into an excel sheet.
This is required to consolidate the performance rating.
Can you guys suggest me a way to get it...?
Thanking you in advance,
Dee...
Hi All,
I have 2 ranges one is Self & 2nd one is Manager. If average of self range is >=2 then L1,if it is >3 & <4 it is L3 & if it is <= 5 it is L3. same condition applies for Manager range also. For the value in self range the answer should be average of self range & Manager...
Hi Faseeh,
My data looks like this
Rank Confidence level (%)
1 80
3 45
9 56
27 80
81 45
27 75
First it considers only >= 9 ranking and from that corresponding confidence levels it has to pick the minimum conf level
In this example...
Hi Guys,
I have two columns say Rank & Confidence.
if ranking is more than or equal to 9 then the minimum of corresponding confidence level should come in Cell A3.
i tried using extra column but was not satisfied, i guess there should be some smarter way of doing it using formula...