• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    calculate percentage based on dynamic denominator

    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...
  2. I

    calculate percentage based on dynamic denominator

    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...
  3. I

    recreate range with out blanks - help with formula

    Dear Mr. Rahul, this works like a dream, thank you for your help. Much appreciated. Regards, Izhar
  4. I

    recreate range with out blanks - help with formula

    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...
  5. I

    Excel IF condition formula help

    thank you Mr. Bosco, works like a dream. Regards, Izhar
  6. I

    Excel IF condition formula help

    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
  7. I

    how to calculate percentage with consistency

    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...
  8. I

    negative number to postive numbers in pivot table/ line graph

    Many Thanks, works like a dream can you please share how you went about doing this? Thanks,
  9. I

    negative number to postive numbers in pivot table/ line graph

    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...
  10. I

    negative number to postive numbers in pivot table/ line graph

    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
  11. I

    how to search Individual column (text inputs) in excel

    Dear SirJB7, thank you for your help i really appreciate it.
  12. I

    how to search Individual column (text inputs) in excel

    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...
  13. I

    how to search Individual column (text inputs) in excel

    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
  14. I

    how to search Individual column (text inputs) in excel

    ------------------------------------------------------------------------------------- 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...
  15. I

    how to search Individual column (text inputs) in excel

    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...
  16. I

    access 2010 help with developing a split preview (non editing)

    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
  17. I

    Help With Time Line using Scatter Plot

    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
  18. I

    Help With Time Line using Scatter Plot

    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
  19. I

    Help With Time Line using Scatter Plot

    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
  20. I

    calculate hourly rate with conditions

    Dear @vletm Please do the send the sample. Thanks
  21. I

    calculate hourly rate with conditions

    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...
  22. I

    calculate hourly rate with conditions

    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...
  23. I

    Cost of Owning and running a car

    thanks incidentally that file from "car cost" was what i got through my search thanks
  24. I

    Cost of Owning and running a car

    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
Back
Top