Excel Worksheet Functions | Forum profile

Correction to the formulas =COUNTIF($B$2:$B$10,B2)=1 and for entire column =COUNTIF(B:B,B1)=1 If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: > Using data validation you can; but only manual entries/dropdown entries will > be validated > > --Select B2:B10 > --Select menu Data>Validation > --Select Custom from the 'Allow' dropdown and...

>=AND($A2<>"",SUMPRODUCT(--($A$2:$A2&"^^"&$B$2:B2=A2&"^^"&B2))<2) And to be consistent, the column refs don't need to be absolute: =AND(A2<>"",SUMPRODUCT(--(A$2:A2&"^^"&B$2:B2=A2&"^^"&B2))<2) -- Biff Microsoft Excel MVP...

Hi, Tey this http://datapigtechnologies.com/blog/...iles-method-2/ -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Satya Nanduri" > wrote in message ... > Well, I meant 15 workbooks (or as per your email they are different files > like Inventory1.xls, Inventory2.xls upto 15. I need to consolidate the > data > and generate reports. I am not getting a logical way to do...

1 foot = 0.3048 m, so the formula you need is =A1/(0.3048^3) -- David Biddulph "M-A H" > wrote in message ... > Wish to convert CBM [Cubic Meter] to FT3 [Cubic Feet] andy suggestions on > what the formula should be..? > TY

Just thought of something else. You can use this technique to seep up your calculations: Speed up Workbook: put these at the beginning of your code: Application.Calculation = xlCalculationManual Application.ScreenUpdating = False and these at the end Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking...

If you are expecitng the below results...try the below formula which uses WEEKDAY() Start date finish date 1/1/2009 2/1/2009 3/1/2009 3-Jan-09 27-Jan-09 17 0 0 24-Feb-09 0 4 22 25-Feb-09 12-Mar-09 0 3 9 =MAX(0,SUM(INT((WEEKDAY(MAX(C$1,$A2)-{1,2,3,4,5},2)+MIN(IF($B2="",TODAY(),$B2),DATE(YEA R(C$1),MONTH(C$1)+1,0))-MAX(C$1,$A2))/7))) If this post helps click Yes --------------- Jacob Skaria "Kimti" wrote:...

Thank you so much, Jacob. Actually, it was working. "Jacob Skaria" wrote: > The posted formula will consider not just AA or BB for a matching but all > cells in the range B1:B20 for a match. Try changing that reference to B1:B2 > with B1 entered with 'AA' and B2 entered with 'BB'... > > If this post helps click Yes > --------------- > Jacob Skaria >...

Can you tell us how you are getting the running time? Are you using =NOW() and what cell is this in? What are the 6 time ranges that you want the message to be active for? Which cell do you want to use to display the message? Pete On Nov 18, 11:51*pm, KT > wrote: > I have put the running time on a worksheet. *I want to reference that time > and for 6 time ranges during the day, I want to display a message to the user...

Raul, If your month's data is a single column, and the column headings are labels rather than actual dates: =SUMIF(Sheet2!A:A,B3,INDEX(Sheet2!1:65536,,MATCH(B 4,Sheet2!1:1,FALSE))) Where B3 has the Project, and B4 has the Month entered in a way that matches the column header labels. If you have mutliple labels for months, then try array entering (enter using Ctrl-Shift-Enter) a formula like...

See Chip Pearson's site. http://www.cpearson.com/excel/FirstLast.htm Gord Dibben MS Excel MVP On Tue, 24 Nov 2009 10:53:02 -0800, kathy at the front desk <kathy at the front