Search results

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 Just for Learning !!

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 Experts, What is the use of Match type in Match formula, For any Value/ Not given entered , It gives same result Thanks

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