Hi,
How to find out the names alone from a line.
Ex: 1. Senthil Kannan Ram working in abc company 2. vinoth kumar working in xyz company
Now i want a formula to extract the names only for
1. Senthil Kannan Ram
2. vinoth kumar
Any help.
Thanks,
SK
Hi,
I have created a macro and saved it as 2007 Add-in file now. how i will add that add-in the activeworkbook or how i will run that particular macro.
Thanks,
Suresh Kumar S
Hi,
I have a data where the header may move from 35 to 45 (after running the report may be first time it will be in 35 and second time will come down to 45 )how do i can declare the title in code.
By default the recorded macro code taken it as.PrintTitleRows = "$35:$40". Now i want to find...
Hi,
I have data in column A with header called Income below that lot of numbers there. i want to add those numbers. i tried sumif and sumifs also but no use. please help me
Thanks,
Suresh Kumar S
Hi,
I have workbook of 5 worksheets and all worksheets contains some formulas. I want to highlight if any other worksheet is linked with active sheet.
Example in Sheet1.A1 =B1+Sheet2!B1 in this case is it possible to highlight either by macro or conditional format or some other tricks...
Hi,
I have a set of data in sheet1 and sheet2 by using Trace Precedents is it possible to figure out all the cells in both the sheets.
Example i have formula in sheet1 on E4 = E3+Sheet2!E3. Now by using Trace Precedents i am able to find out the E3 (sheets1) cells but it is not selecting...
Hi,
I have some formula without String ($) now i want replace the formula with string function.
Suppose A1 =C1+D1 i want A1 = $C$1+$D$1
Thanks,
Suresh Kumar S
Hi,
I want to compare 2 formulas and if there is mismatch it should highlight(Conditional format)
Example:
A3 AA3 - No Changes
$A4 $A4 - Highlight ( It suppose to be $AA4)
Thanks,
Suresh Kumar S
Hi,
Please refer the below below sheet and give me a solution. (I want the result column to be filled by formula)
http://www.2shared.com/file/AICNqcSJ/Book7.html
Thanks,
Suresh Kumar S
Hi,
I have a source sheet and I want the result in the below file. I have explained what I want. Excel hero please suggest a formula and give an idea to overcome this issue.
http://www.2shared.com/file/U5J2eaGa/Book1.html
Thanks,
Suresh Kumar S
Hi,
I have create 4 CheckBoxes if all the four CheckBoxes are not checked then the macro(already i have) should not run and it should through error message "Please select the above option". Please provide a code of me.
Thanks,
Suresh Kumar S
Hi,
I have the following dates and i want the sum of each months.
24-Jan-13
28-Jan-13
31-Jan-13
01-Feb-13
05-Feb-13
Output:
Jan-13 3
Feb-13 2
Thanks,
Suresh Kumar S
Hi,
I have workbook with different sheets with different range (in each sheet) i want to print out all the sheets with all the different range in one page for each sheet. Any Macro is there?
Thanks,
Suresh Kumar S
Hi,
How do I will compare 2 different format dates?
A1 = 13/02/2012 (DD/MM/YYY/)
B2 = 20100213 (YYYYMMDD)
C2 = TRUE ( I need formula)
Thanks in advance,
Suresh Kumar S
Hi,
Suppose I have data from A1:A14 as shown below
1
2
3
4
5
6
7
8
9
10
11
12
13
14
I want a formula to combine all the numbers to one like
1,2,3,4,5,6,7,8,9,10,11,12,13,14
Thanks,
Suresh Kumar S
Hi,
Suppose i have a set of number
1.100
1.208
1.098
and i want to add text " done" to the list with extact value like
1.100 done
1.208 done
1.098 done
How it can be combined using formula.
Thanks,
Suresh Kumar S
Hi,
I am looking for blocking a seat for different shifts in excel format (similar to movie ticket booking.....Select date,select # of seats,showtime & Price). Does any body have or help on this.
Thanks in advance,
Suresh Kumar S
Hi,
I want to sum all the production hours, present days and no of working days for a particular month. I have briefly explained in attachment.
http://www.2shared.com/document/9cTqJACO/1_online.html
Thanks,
Suresh Kumar S
Hi,
I have sheet of file size 34 mb. As per the request I have to copy 70 cells and paste for 2,00,000 cells.(I am able to perform the copy and paste the formula for max of 1000 rows only - due to some restriction in excel). After pasting formulas in all the 2,00,000 cells the file size has...
Hi,
I have list of years and i want to remove * special character alone from the list.
Source:
2009
2010*
2011*
2012
Output:
2009
2010
2011
2012
Thanks,
Suresh Kumar S
Hi,
Suppose in A COLUMN contains both text as well as number how I can filter only text (without using multiple option from dropdown).
Thanks,
Suresh Kumar S