Re: $$Excel-Macros$$ Need a MAXIF type formula

2010-11-19 Thread ratu elissa
i don't really understand what you ask for On Fri, Nov 19, 2010 at 11:45 PM, None n8dine4ma...@yahoo.com wrote: I need a MaxIf type of formula that will work with Excel 97 and Excel 2003. Thanks. I have two worksheets that have similar data in them for Col A-C. Sheet 1 has numbers in col

Re: $$Excel-Macros$$ sum duplicate value

2010-11-14 Thread ratu elissa
use SUMIF Formula On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna bhavya...@gmail.com wrote: Hi Everyone. Can someone explain I have data in sheet 1 The columns Name and Production . Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name and fetch the production . But I

$$Excel-Macros$$ 3 last digit

2010-11-14 Thread ratu elissa
Please Help Me How to create automatic code in the attachment -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

2010-10-27 Thread ratu elissa
try this: =TEXT(C3; dd/mm/ hh:mm:ss) On Wed, Oct 27, 2010 at 4:26 PM, Anju anjulav...@gmail.com wrote: Hi , Please help to format the dates in attached excel file to dd/mm/ hh:mm:ss. when i treid formating the dates somedates format was dd/mm/yy hh:mm:ss...but i need as dd/mm/

Re: $$Excel-Macros$$ Re: Manipulating Userform controls' back color by one routine instead of separate change routines

2010-10-27 Thread ratu elissa
can you give the attachment please On Wed, Oct 27, 2010 at 7:57 PM, learner mahessbde...@gmail.com wrote: Hi! Ashish, This does not work. I pasted the code after clicking the form in the empty sub with required changes of the names. But entering and exiting the TextBoxes + ComboBoxes do not

Re: $$Excel-Macros$$ Need Suggestion!

2010-10-26 Thread ratu elissa
ok On Tue, Oct 26, 2010 at 12:19 PM, amrahs k amrahs...@gmail.com wrote: Dear Experts, I need quick suggestion to solve the below issue. Issue: Team use to update a spreadsheet for tracking their hours details for extending the shift. After a day the values in the spreadsheet gets changed

Re: $$Excel-Macros$$ Re: Sales Territory's MAP

2010-10-26 Thread ratu elissa
The url's can't be opened On Tue, Oct 26, 2010 at 1:35 PM, anandydr anand...@gmail.com wrote: Hi, Please see Tushar Mehta's website. http://www.tushar-mehta.com/excel/charts/0301-dashboard-conditionalshapecolors.htm Check this site for creating the kind of map you want. I hope this

Re: $$Excel-Macros$$ manage lengthy database

2010-10-26 Thread ratu elissa
How about when we move the the cursor into row 10 the color of range B10:M10 is yellow thanks On Tue, Oct 26, 2010 at 11:27 AM, ashish koul koul.ash...@gmail.com wrote: HI use it ony if you are not using any background colors in file code: Private Sub Worksheet_SelectionChange( ByVal