Recent content by senthilkumar_rm

Dear Arun , Not working !! - It is taking the corresponding row data not the filtered - unable to paste

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 ??

Can u please explain the formula i dont understand -- infront of mod

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

Thanks Roy But i have data of whole list , I need it on Vlookup

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