For Option 2 and 3 !
I use mostly office 2013, sharing would create problem also noticed when any company is completely removed summary gives error in Option 2.
Option 1: :cool:
But I prefer formulas instead of vb, as while sharing people are afraid of script codes:rolleyes: and even sometimes...
Hi,
Greetings Happy new year 2017,
I am trying to create a summary from a table but zeros are making problem for me.
Any ideas. I just want to add only products which were sold to any company.
Thanks
Hi Guys & Grlz,
I was working on this database and got stuck, i hope some one can help?
The idea is "A company keeping tracking of renting equipments and customers.
The customer can take multiple equipments.
Each equipment has a unique ID. (alphanumeric - XXXX#####) depending on the selection...
Well now there is Google spreadsheet available btw i am not fan of excel but i always most of my solutions in excel. i wish excel could use filter as easy as Google, import other files as easy as Google.:rolleyes:
adding the helper column did work but there is still a problem the values for January are not coming correct as it is counting the values for sub tasks as well.
Hi,
i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working
H1 : is my selection month
Row B3:M3 is my date
Row B4:M4 is my data which is i am adding using above formula.:awesome:
Thanks
Hi,
Did anyone tried to link excel data with visio 2013 to create graphs ?
I was trying to link excel data with visio by: (try any data) so if i change value i excel it should also reflects in visio graphs.
In Vision 2013,
Under Data Menu
>Link Data to Shapes
>Data Graphics
I like...
Look at project 5 and project 7.
project 7 will be reject as it will not fall with in our calender but project 5 will over drawn as it exceeds our calender.
That was quick reply, but if you notice the date i want is in financial year and that's fixed if "end date falls with that date chart would look fine but if date goes above my FY13. it should plot whole line. (look project 4)
I was thinking about putting an extra column and hiding it but still...