Search:

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

Page 1 of 7 1

1. Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by farrukh
Replies
11
Views
683

Sir Steve, Thank you very much formula you...

Sir Steve,

Thank you very much formula you provided works perfectly !

Sorry due to Writing English I mean that value when we put like in decimal points e.g ( 0.21, 0.2, ) the formula not...
2. Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by farrukh
Replies
11
Views
683

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 ...
3. Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by farrukh
Replies
11
Views
683

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 ...
4. Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by farrukh
Replies
11
Views
683

Sorry correction ! Require 4 sheets Weekly...

Sorry correction !

Require 4 sheets
Weekly
Monthly Quartely
Yearly.
5. Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by farrukh
Replies
11
Views
683

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
6. Thread: Aggregate daily data to new sheets monthly, quarterly, yearly

by farrukh
Replies
11
Views
683

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
7. Thread: Two updates query needs to be used in IF ELSE condition in Stored procedure

by farrukh
Replies
0
Views
183

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...
8. Thread: Match columns A,B in two sheets and Bring ColumC data

by farrukh
Replies
4
Views
251

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...
9. Thread: Daily,Weekly,MTD, YTD, LTD Sql query range wise

by farrukh
Replies
0
Views
420

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

by farrukh
Replies
3
Views
250

Sir,
11. Thread: Open attachements based on start date end date

by farrukh
Replies
3
Views
250

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...
12. Thread: Need five days average of stable values for stable unstable data

by farrukh
Replies
3
Views
753

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
13. Thread: Mandatory entry in column if other column values less than 24

by farrukh
Replies
1
Views
600

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...
14. Thread: Get Sequence of Date then sum in sum sheet

by farrukh
Replies
10
Views
805

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

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

by farrukh
Replies
3
Views
753

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.
...
16. Thread: Get Sequence of Date then sum in sum sheet

by farrukh
Replies
10
Views
805

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:
17. Thread: Get Sequence of Date then sum in sum sheet

by farrukh
Replies
10
Views
805

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)
18. Thread: Get Sequence of Date then sum in sum sheet

by farrukh
Replies
10
Views
805

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...
19. Thread: Get Sequence of Date then sum in sum sheet

by farrukh
Replies
10
Views
805

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...
20. Thread: Get Sequence of Date then sum in sum sheet

by farrukh
Replies
10
Views
805

Get Sequence of Date then sum in sum sheet

Hello Gurus,

I have one calculation sheet and other is Sum sheet. In the calculation sheet dates are random suppose in the month of november...
21. Thread: IF find Zero average the previous 5 values greater then 0

by farrukh
Replies
7
Views
582

Thanks sir works perfectly :)

Thanks sir works perfectly :)
22. Thread: IF find Zero average the previous 5 values greater then 0

by farrukh
Replies
7
Views
582

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
23. Thread: IF find Zero average the previous 5 values greater then 0

by farrukh
Replies
7
Views
582

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.

24. Thread: each worksheets in a folder copy header and last row paste masterworkbook

by farrukh
Replies
6
Views
618

Respected Zeddy, Awesome ! Thanks you really...

Respected Zeddy,

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

God Bless you always...
25. Thread: each worksheets in a folder copy header and last row paste masterworkbook

by farrukh
Replies
6
Views
618

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
Results 1 to 25 of 172
Page 1 of 7 1