Search:

Type: Posts; User: farrukh; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Dear While Google I search one file from...

    Dear

    While Google I search one file from forum which is attached . It perfectly works according to my needs but I face problem in Average if vales starts from without decimal the average works ...
  2. Thank for your reply Actually I have years of...

    Thank for your reply
    Actually I have years of data every time filtering the data may do the human mistake and get the wrong figures. Is it any way to get data in different sheets ...
  3. Sorry correction ! Require 4 sheets Weekly...

    Sorry correction !

    Require 4 sheets
    Weekly
    Monthly Quartely
    Yearly.
  4. Hi I have attached the file sum columns needs...

    Hi
    I have attached the file sum columns needs to get weekly sum, some get weekly average .Same for Monthly and Yearly.
    My week always starts from Thursday to Wednesday
  5. Aggregate daily data to new sheets monthly, quarterly, yearly

    Dear Experts !
    I have a long excel sheet data for many years on daily basis. I need to sum this data on monthly ,quarterly and yearly basis in 3 separate sheets?

    Thanks
  6. Two updates query needs to be used in IF ELSE condition in Stored procedure

    Hello Expert !
    I need your help to make SP to work on if Else condition . I have one column name which is not added in below update query which is Hours. I need that if Hours > 0 then run first...
  7. Match columns A,B in two sheets and Bring ColumC data

    Hello All,

    I have two worksheet having (Match1 ) Sheet and (Match2) sheet . I require match1 sheet column AB with Match2 sheet if matched then bring column C of Match2 sheet to Column C in Match1...
  8. Daily,Weekly,MTD, YTD, LTD Sql query range wise

    Hello Experts !
    I need to show the sqlserver database data like Daily ,Weekly, MTD, YTD and LTD. I googled and find sql query example in it but one link for using calander table no longer exist ....
  9. Sir, Please find attached the sample excel file...

    Sir,
    Please find attached the sample excel file please.
  10. Open attachements based on start date end date

    Dear Gurus,

    I need calendar control in first column start dates and second column end date (end date fixed by user) third column The names ,fourth column PDF files extensions and fifth videos...
  11. Dear Daianel, Many thanks for your reply ,no...

    Dear Daianel,
    Many thanks for your reply ,no still I unable to get any solution or way to resolve this issue... I am doing manually after generating my report. Please help

    Best regards
  12. Mandatory entry in column if other column values less than 24

    Hello Experts!

    I have column C which contains hours on and in column O is blank for code entery. I need if column c Values less then 24 so a popup comes you need to enter the code in the column O...
  13. Replies
    10
    Views
    740

    Sdckpar many thanks worked perfectly... Thanks...

    Sdckpar many thanks worked perfectly...
    Thanks for help
  14. Need five days average of stable values for stable unstable data

    Hello All...
    I have column which contains stable unstable data. I need to get the last five days average of stable data when unstable values comes. I mean last five days average of stable days.
    ...
  15. Replies
    10
    Views
    740

    Ahh sorry in the sampler i copy paste the...

    Ahh sorry in the sampler i copy paste the values.Please see the attached spreadsheet what i am doing wrong.
    :confused::confused:
  16. Replies
    10
    Views
    740

    Thanks Sdckpar, Exactly your post # 4 works for...

    Thanks Sdckpar,
    Exactly your post # 4 works for me . I am unable to fix the below formula to get the sum.

    =SUMIFS(Caculation!$G$4:$G40,Caculation!$B4:$B40," >="&B4,Caculation!$B4:$B40,"<="&C4)
  17. Replies
    10
    Views
    740

    37225 Hello sdckapr, Sorry i think i unable...

    37225

    Hello sdckapr,

    Sorry i think i unable to clear my forum help.

    Actually the Sum sheet will be created automatically there is no match case.
    I have given the coloring to cells to make...
  18. Replies
    10
    Views
    740

    37212 Hello sdckapr, The formula will get...

    37212

    Hello sdckapr,

    The formula will get me the sum from calculation sheet but what about date range. For date range i need if dates are going in the sequence suppose 2-nov-13 then 3-nov-13...
  19. Replies
    10
    Views
    740

    Get Sequence of Date then sum in sum sheet

    Hello Gurus,

    I am really stuck in my senario please help me out.

    I have one calculation sheet and other is Sum sheet. In the calculation sheet dates are random suppose in the month of november...
  20. Thanks sir works perfectly :)

    Thanks sir works perfectly :)
  21. Sir RetiredGeek, Thanks very much it is...

    Sir RetiredGeek,

    Thanks very much it is exaclty my need, just only if the values having decimal places the function does not count correct average. The sample is attached.

    Thanks Sir
  22. IF find Zero average the previous 5 values greater then 0

    Hello All,

    I need some formula works if in the column find zero then pick the average of last previous 5 values by excluding zeros. The file is attached with required results.

    Thanks in advance
  23. Respected Zeddy, Awesome ! Thanks you really...

    Respected Zeddy,

    Awesome ! Thanks you really i dont have words to say thanks...

    God Bless you always...
  24. Respected Zeddy no issue have a very safe Journey...

    Respected Zeddy no issue have a very safe Journey precious man... if possible will you share your picture want to see a kind man to humanity.
    Email=farrukhhameed786@gmail.com
  25. Hello Respected, Thank you very much for...

    Hello Respected,
    Thank you very much for reply...
    I want to append the data in master workbook beneath each other.

    I am attaching the Sampler test.xlsx and Master.xlsx . In the Master file the...
Results 1 to 25 of 171
Page 1 of 7 1 2 3 4