Good morning,
thank you for taking the time to reply
the goal is to automate the denominator so when M Q or Y is selected the appropriate calculation comes uo.
the data is from an external file the M, Q, Y are added by me.
if a data is required use the 1st of every month
feel free to...
hello folks,
in the attached sheet there are columns g to j calculate the ops cost as a % of revenue based on month, quarter, year and global.
I want to create a pivot graph with the slicers for month, quarter, year, global, status and country
And based on my selection for the time...
Good morning folks,
i have range of data with some number information against it. i wish to recreate the same range with out any blanks
orginal range
range1 2014
AL 5
AU 6
CH
CO 7
EG 8
IN
IR 9
IR 10
KE
KU
ME 1
OM 1
PA 12
recreated range
range1 2014
AL 5
AU 6
CO 7
EG 8
IR 9
IR 10
ME...
hello folks,
i have a 2 column with TRUE and FALSE
need your help with a formula to give me the proper number for the below key
true true - 1
true false - 2
false false - 3
false true - 4
Thanks,
Izhar
how to calculate percentage with consistency in pivots
I have financial data over a period of time for which I need to calculate Ops cost as % of revnue
My problem is depending up the period I look at the percentages add up differently that is month, year and global
I want the calculation...
thank you for your reply and solution
soloves the issue in a easier way than what i thought, however there is another problem
i want the chart to auto arrange for scale that is if i choose to have fewer Row labels the line chart should show chart for only those items selected and not the...
Good Morning,
i have finance data that has credit values (-ve) when i use this data
i want to flip the blue line in the attacment to show as + ve and run with the red line
dont want to change the source data
please help
thanks
Dear SIRJB7, me being completly novocie to vba have not figured out how to break down the given code to accomodate on my file, i was wondering if you could do the same for the attached file and if you could explain a little on range selection, and selection of columns it will be very helpful...
Dear SirJB7,
thank you so much for doing this i really appreciate it.
i was wondering if you could guide me to a resourse for me to learn the vba coding and learn to perform these funtions on my own.
thanks again,
Izhar
-------------------------------------------------------------------------------------
Thank SirJB7 for the solution; i am a step closer to what i am ultimately looking for.
want to further explore this, is there a possibility to modify this vba to do away with the filter and show all buttons...
Hello folks,
I have a huge database that i have to constantly search for different sort of information arranged in many columns.
With multiple filters i am able to get to the information i need (the result in multiple rows)
However i am able to get to my desired information much faster and...
hello,
i am trying to develop a split preview (see attached sample screen shot) for my database in access 2010
i am completly lost any direction for me will be really appericated.
Thanks,
Izhar
i agree
can you please walk me through as to how to create a gantt chart with the help of screen shots?
in the sample file i tried modifying the x axis to change the date range with a three day interval but could not figure it out.
thanks for all your help
Thank you for reply
i wanted to do this https://www.officetimeline.com/excel-timeline
however i am using excel 2010, which does not have give me the options to edit my scattor plot to get the results i want
i am sttudying your chart in the mean time if it is a better soloution
Folks,
i need your help with the attached file to develop and format a Time Line using Scatter Plot
please see the attached file and help me make a time line with Item description
many thanks,
Izhar
Post Moved by Mod
Thank you @vletm
now i have another twist, the workers have a split in their hourly rate, as in from 22:00 hrs to 06:00 hrs they have a particular rate say 1.25 and on the weekends for the same time they have the rate as 1.5 of the base rate.
please note that in case the shift starts before...
hi,
i have an issue using the appropriate formula to determine the rate to be used for difirent scenarios
1/ day shift 2/ night shift and 3/ nigth shift weekend
i was wondering if i could get some help with a formula in the 'hour rate' cell
also need to consider the trade and company...
Hi,
i am trying to find if any one has worked on calculating cost of owning and running a car on MS excel. i dont want to reinvent the wheel, so checking if some has already worked on this and is willing to share his file/work.
Thanks,
Izhar