Welcome, Guest
You have to register before you can post on our site.

Email:
  

Password
  





Forum Statistics
» Members: 623
» Latest member: ajaysharma8532
» Forum threads: 760
» Forum posts: 1,872

Full Statistics

Latest Threads
Sum Function
Forum: Ask Excel Question
Last Post: Sajan
25-Nov-2021, 01:10 PM
» Replies: 4
» Views: 1,748
VBA check if
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
12-Jan-2021, 08:45 PM
» Replies: 1
» Views: 1,116
Dependent Drop Down
Forum: Ask Excel Question
Last Post: Anil Kumar Pal
23-Nov-2020, 10:05 AM
» Replies: 1
» Views: 798
for and next
Forum: Ask VBA Question
Last Post: Abhay
08-Sep-2020, 03:26 PM
» Replies: 0
» Views: 853
PAN NO. FORMULA
Forum: Ask Excel Question
Last Post: dsharma789@rediffmail.com
06-Jul-2020, 11:51 AM
» Replies: 0
» Views: 892
Getting error while tryin...
Forum: Ask VBA Question
Last Post: Rinku Sharma
25-Jun-2020, 09:01 PM
» Replies: 0
» Views: 721
Hyperlink Pivot table dat...
Forum: Ask Excel Question
Last Post: sanj_edu
14-Jun-2020, 06:37 PM
» Replies: 0
» Views: 710
Calculate idle time no mo...
Forum: Ask VBA Question
Last Post: Inderjeet Pal
28-Apr-2020, 11:59 AM
» Replies: 0
» Views: 823
Making Pivot table
Forum: Ask Excel Question
Last Post: Vivekananda Sinha
17-Feb-2020, 12:39 PM
» Replies: 1
» Views: 1,162
Need help on code
Forum: Ask VBA Question
Last Post: Inderjeet Pal
15-Feb-2020, 04:23 PM
» Replies: 0
» Views: 871
Date Selection In Range
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 02:03 PM
» Replies: 1
» Views: 1,100
count
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 01:19 PM
» Replies: 3
» Views: 1,866
Array
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 12:16 PM
» Replies: 4
» Views: 1,793
find unique values as hig...
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 10:07 PM
» Replies: 4
» Views: 2,662
add numbers in a cell
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 08:36 PM
» Replies: 0
» Views: 788

 
  Stack Ranking
Posted by: rawat7838 - 22-Jun-2019, 12:52 PM - Forum: Ask Excel Question - No Replies

Hi All,

Please help me out to calculate Stack Ranking on behalf of the month data.

Note :- Weightage and KPI Target Campaign wise are mention.


Prashant Rawat



Attached Files
.xlsx   stack ranking.xlsx (Size: 10.44 KB / Downloads: 19)

  File is not opening
Posted by: Chandan kumar - 18-Jun-2019, 04:59 PM - Forum: Ask VBA Question - Replies (2)

Hi All,

Please help as I am not able to open a Particular file. When I am opening the file getting the error. "Can't find the project or library".


Regards
Chandan Kumar



Attached Files Thumbnail(s)
   

  Count of Students with criteria of greater than less than
Posted by: Neeraj Kumar Maurya - 17-Jun-2019, 10:15 AM - Forum: Ask Excel Question - Replies (5)

Please help..... to count of student, criteria mention in the file.

Thanks
Neeraj Maurya



Attached Files
.xlsx   Count with greater than less than.xlsx (Size: 13.98 KB / Downloads: 15)

  Pick Multiple Values From Single Identity
Posted by: @m!t $@!n! - 11-Jun-2019, 12:52 AM - Forum: Ask Excel Question - Replies (2)

Hi Sir,

PFA and resolve query asap.



Attached Files
.xlsx   Queries.xlsx (Size: 24.78 KB / Downloads: 19)

  If with vlookup for time ( HH:MM:SS)
Posted by: Amit5210 - 06-Jun-2019, 05:54 PM - Forum: Ask Excel Question - No Replies

Hi Experts,

Hoping you are doing well,

I am trying to fix a formula for IF condition with Vlookup but output are not coming.

Can you please help me on this?

Please see the attached file and suggest. Smile


Hi All,

Thank you! I have fixed the formula.

=IF(AND(TEXT(VLOOKUP($A$1,'Raw Data'!$A:$D,4,0),"hh:mm:ss")<=TEXT(TIME(0,3,40),"hh:mm:ss"),TEXT(VLOOKUP($A$1,'Raw Data'!$A:$D,4,0),"hh:mm:ss")>TEXT(TIME(0,3,20),"hh:mm:ss")),VLOOKUP($A$1,'Raw Data'!$A:$D,4,0),0)



Attached Files
.xlsx   IF with Vlookup Condition.xlsx (Size: 10.45 KB / Downloads: 19)

  Dynamic Range Calculation
Posted by: Manish Kumar Gera - 06-Jun-2019, 09:56 AM - Forum: Ask Excel Question - Replies (2)

Hi All,

I have a query. In the attached sheet i have a tab Total Tax Paid which is highlighted in Yellow color. There is another tab Total Tax Paid Till  Now. I want to make the dynamic range in which, if i add some amount in total tax paid (Yellow color) then in the another tab which is total tax paid till now should be changed.

For example:

If i add 20 in A section of total tax paid then in total tax paid till now should be changed and amount would be 30. I want it would be show in all A B C section.



Attached Files
.xlsx   Excel_Manish.xlsx (Size: 11.47 KB / Downloads: 9)

  How to sum the total sale from April to a given month
Posted by: Sweyam - 02-Jun-2019, 09:07 PM - Forum: Ask Excel Question - Replies (1)

Hi All,

Please provide the solution of attached file

Thanks

Amit



Attached Files
.xlsx   Question.xlsx (Size: 10.57 KB / Downloads: 20)

  How to make dynamic two RAW switch in single Pivot
Posted by: Amitg9595 - 01-Jun-2019, 05:11 PM - Forum: Ask Excel Question - No Replies

Hi folks,

I have attached a sheet, Kindly have a look and suggest the best way to make pivot table a switchable between two given raw sheets.
Mean to say I have to raw of different locations but with exact same format and i wish to switch my one pivot table on both that raw.


Regards,
Amit Sharma



Attached Files
.xlsb   How to navigate two RAW in one Pivot.xlsb (Size: 23.66 KB / Downloads: 7)

  SQL Connectivity
Posted by: Chandan kumar - 29-May-2019, 09:00 PM - Forum: Ask SQL Server Question - Replies (2)

Hi All,

I have installed SQL server into my system. But I am not able to login into the SQL. It is giving an error.

Please help how to resolve it.

Attached is the error screenshot.


Regards
Chandan Kumar



Attached Files
.xlsx   Error Screen Shot.xlsx (Size: 25.98 KB / Downloads: 3)

  Find Working days
Posted by: Jyoti - 28-May-2019, 03:31 PM - Forum: Ask Excel Question - Replies (2)

Hi all,

can you help me for solve this question.



Attached Files
.xlsx   Question.xlsx (Size: 10.62 KB / Downloads: 10)