Dear Excel experts ,
I have a excel file with 2 sheets -
From Sheet 2 need to paste data to sheet 1 which is filtered ; whereas sheet 2 is not filtered
See uploaded file for same -
Need to fill the column A " Final remarks " from DATA 2 sheet
DATA - sheet 1 - Filtered
DATA 2 - Sheet 2 -...
Dear Solvers,
I have data from A column to E column ,In Which E column(Status) has conditional formatting to Red Green Yellow
Need no.of red, green , yellow items
dear solvers
I have details of employee as
A B C
Senthil Quality 5, MGR street, Tambaram
I need as (Please note i want below like in a single cell)
Senthil
Quality
5,MGR Street
Dear Solvers,
i got the answer for summing up of only even numbers in a series of data
but solver has used -- infront of MOD formula
can u please explain why the solver has put -- what is this ??
Dear Solvers,
I have a series of data where it consists of Odd and even numbers in A column
I would like to add(Sum) only the even numbers using a formula
Dear Experts,
I have the data as below
Column A
Row 1 23
Row 2 45
Row 3 46
...
Like i have data upto row # 566 - I Need to add a blank row in between each row ,
suggest me some short cut to add the blank rows in single one shot / easy
Thanks
Hi Solvers,
Suppose i have data like this
A B
Type Value
Part 1 3.62
Part 1 2.63
Part 1 3.65
Part 1 2.00
When i tried to put a vlookup for part 1 it retrieves only the first value whereas i want the min value
answer retrieved is 3.62 but i need 2.00 (Min value of same part #)
Hi solvers
I have a data in a cell A1 = 23456 with insert comment as north
want to provide a link to another sheet ,where i need both insert comment and data
thanks
Senthilkumar RM
Dear Expert solvers,
We had a scenario where needs to fulfill as when data as
Data
A B C D E
row1 12 23 44 55 65
Requirement
When i place my cursor in B1 it has to show graph(trend) by fetching A1 & B1
whreas when i place at column E it has to show graph upto E by...
Hi solvers
I have scenario where i want to get values by looking up the value in other cells
find below is criteria, i need a formula which looks the value in cell C3 and displays the corresponding value
A column B Column
Criteria Value C1 = 99.4
100 25...
Dear solvers,
I have an excel which need to be printed as many copies, No.of copies has to be fetched from a cell in that file( say = D4)
what can be the macro code
Senthilkumar RM
I have data as
C5 = text1
D6 = text2
E7 = Text3
F8 = text4
i need the output as
G5 = Text1 (= C5)
G6 = text2 (= D6)
G7 = text3 (= E7)
G8 = text4 (= F8)
I have tried what i know, please help me in solving this
Region Customer Name Sales
East Mahesh 3300
East Shahul 2300
East Prabakar 1400
East Samsu 2345
East Perumal 1234
West Mahesh 889.7
West Shahul 481
West Prabakar 72.3
West Samsu 7300
North Perumal 2344
North Mahesh 1323
North Shahul 6777
North Prabakar 6554
North Samsu 7773
South...
Region Customer Name Sales
East Mahesh 3300
East Shahul 2300
East Prabakar 1400
East Samsu 2345
East Perumal 1234
West Mahesh 889.7
West Shahul 481
West Prabakar 72.3
West Samsu 7300
North Perumal 2344
North Mahesh 1323
North Shahul 6777
North Prabakar 6554
North Samsu 7773
South...
Hi Solvers
When i drag auto fill option is not visible ( That "+"sign usually appears in bottom right corner of cell and it is used for draging formulas and numbers )
Where can i found the option to sort it down -
Ps : In 2003 & 2007
Dear Solvers,
I have a huge amount of data in an Excel sheet , Where almost all the cells have insert comments
Problem encountered is that , Some of Insert comments are showing only the arrow mark not the inside comment , When i right clicked and showed comment it is showing somewhere else...
Dear Experts,
Here i need the solution
In an excel sheet 1 cell A1 with text "Senthil" and insert comment with "Quality Department"
When i call the cell in sheet2 D5 cell (=sheet1!A1) i got the answer Senthil but not the comment
Is there any method or technique to get the comment also
Dear Solvers,
I have a sheet which needs to be printed,I Have inserted two button for printing
say
Button -1 : A4 size print
Button -2 : A3 Size Print
Need to Write a macro for, If user chooses A4 print, Page has to align (fit) for A4 landscape and printed and if user chooses A3 Print...
Hi Solvers,
I Have file name as D:DataPersonalsramasamdesktopExceldata.xls
Want to find the 4th Slash() what is simple way
Find Function looks big !!
Thanks
Hi all,
I have data as
Column A Column B
1 Wallpaper some picture object
2 Logo Picture
3 Personalities Picture
In Cell D1 , i have done data validation with list >source > A1 to A3
in cell E1, i need the corresponding picture when i choose D1
Hi Solvers,
Greetings !!
We are in phase of creating a form - Date is one of the field , User has to enter from and to date , For that i want to show a calendar with condition Past - 3 Years from today's date and upto present date, User is not allowed to choose beyond these dates
Thanks
Hi Helpers,
We have completed "MOS Specialist" exam for Excel 2007, We would like to do more learning and get expertises with second level "MOS - Expert"
We are unable to find Training Institute for learning !!
We are In Chennai, India
Thanks
Dear Solvers,
Help Me in solving this !!
I have an sheet, In which user will enter name of person whom he wants to send Mail
for Eg; senthilkumar . The Lotus notes(what we are using) should open and search the address book or directory and show result in To"field automatically
Thanks...