Dear Sir,
Please find the link , i need formula help
https://rapidshare.com/files/2571544105/ACCOUNT_DATA.xlsm
Please open the file and find question in report file sheet
sorry,
i am putting here a link.
https://rapidshare.com/files/264138203/Report_file.xlsm
https://rapidshare.com/files/3921140770/ALL_PERSONS_DETAILS.xlsb
Dear Sir,
I want to a report file from above all persons detail to report file.
in all person details many account handle , from...
Dear Sir,
Please find the link
https://rapidshare.com/files/1074754786/Attendance__January_-__2012_.xlsx
The attendance sheet contains a specific comment in each cell mentioning the status of particular person on particular date.
Now my question is, whether we can get all comments...
Dear sir,
i know this formula SUM('Sheet2'!A1:A5)
but i want
In cell A1 i will enter this formula =(100+200+300+400+500)
and its out put should be in column B
B1 100
B2 200
B3 300
B4 400
B5 500
Dear Sir,
if i entry in cell A1 , =(100+200+300+400+500) then answer will shows 15,000 in same cell.
my question is that , when i entry in cell A1 same like =(100+200+300+400+500) and i want in sheet 2 same this entry as
A1 IN 100
A2 IN 200
A3 IN 300
A4 IN 400
A5 IN 500
is this...
Dear Sir ,
Good morning to you all,
when we add in sheet insert menu - smart art - any image or shape
CAN WE LOCK SMART ART ? BECAUSE NO BODY CAN CHANGE IT
No, i have not added date, i have such this data only and i can't get actual work hours
i used formula =a1-b1
then its wrong ?
as per your requirement is there need date ?
Dear All,
In A1 is 8:30 AM
then B1 is 01:00 AM
after D1 answer is 7:30 hours, this is wrong so please help me
how can i calculate of total hour worked ?
I have no any referring but i want to know that , when we are using this "&" in formula ?
you can explain with any formula test but please explain such as i can understand that why we are using "&" ?