Dear Arun,
Need to paste the data - final remarks column from data 2 to the sheet 1 data
Since in sheet 1 data - some rows are hided as it is filtered -
Data 2 sheet not filtered and the corresponding line item is same
if we use Visible cells option from 1 to 19 row it is pasting whereas...
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
Thanks for formula solution ... but issue is little different I have data as
C5 = text1
D6 = text2
E7 = Text3
F8 = text4
c9 = text 5
D10 = text 6
E11 = text 7
F12 = text 8
i need the output as
G5 = Text1 (= C5)
G6 = text2 (= D6)
G7 = text3 (= E7)
G8 = text4 (= F8)
G9 = text5 (=...
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