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,750
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: 799
for and next
Forum: Ask VBA Question
Last Post: Abhay
08-Sep-2020, 03:26 PM
» Replies: 0
» Views: 855
PAN NO. FORMULA
Forum: Ask Excel Question
Last Post: dsharma789@rediffmail.com
06-Jul-2020, 11:51 AM
» Replies: 0
» Views: 894
Getting error while tryin...
Forum: Ask VBA Question
Last Post: Rinku Sharma
25-Jun-2020, 09:01 PM
» Replies: 0
» Views: 722
Hyperlink Pivot table dat...
Forum: Ask Excel Question
Last Post: sanj_edu
14-Jun-2020, 06:37 PM
» Replies: 0
» Views: 712
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: 873
Date Selection In Range
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 02:03 PM
» Replies: 1
» Views: 1,102
count
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 01:19 PM
» Replies: 3
» Views: 1,867
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: 789

 
  how to if and search conditioan in multiple times in one cell
Posted by: Mohit Sharma - 27-Apr-2017, 11:27 AM - Forum: Ask Excel Question - Replies (5)

agar ek cell main (Electricity,Elect,Power) hain toh use (Electricity) likha hua aye aur agar Rechage likha hua hain ek cell main chahe voh ek cell main kahi bhi ho starting main yah end main toh (Rechage) likha hua aye yeh two condition ek hi formula mai lagani hain. I attached the file for example..


It's Urgent...

Thanks,

Mohit Sharma.



Attached Files
.xlsx   Questions.xlsx (Size: 8.19 KB / Downloads: 39)

  Conditional Grouping / UnGrouping
Posted by: Harshit - 26-Apr-2017, 04:02 PM - Forum: Ask VBA Question - Replies (4)

Hi Folks,

I had a query in Excel related to Conditional Grouping / UnGrouping. 

I have approx 20 tabs which have same data columns, now i want to group each month some columns and some have to ungroup.

For Exp: In Column A:L having Months name (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec).

Now first i ungroup all the data and then perform the next step.

Next step is to group those months who are not two months old from current month.

Now the final out put will see for the month of Apr:

Group Months : Jan, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

Ungroup Months : Feb, Mar

Thanks!


Big Grin Your first interaction with Future in Hands
Posted by: Vivekananda Sinha - 13-Apr-2017, 11:47 PM - Forum: The Lounge - Replies (7)

Please describe your experiences of your first interaction with Future in Hands. Please be honest while writing.


User Introductions
Posted by: Vivekananda Sinha - 13-Apr-2017, 09:41 PM - Forum: The Lounge - Replies (2)

Welcome to Future in Hands Club and feel free to tell us a bit more about yourself.