Search results

May not belong here but since it is a Windows subject: I added a third party addin called Xlookup to my two desktops and laptop. Works great. Problem is, when I take a spreadsheet from one puter to another, it fails to see the addin path because each puter name is different. So I have to...

=IF(ISNUMBER(I4),RANK(I4,$I$4:$I$34)+COUNTIF($I$4:I4,I4)-1,"") This will break ties but it assigns 1, 2, 3, 4 etc starting at the first in the list then the next then the next and so on. Is there a way to have it randomize first second third, or fifth, sixth, etc of those tied? Thanks in...

I added the xLookup addin to 2 pcs and a laptop. When I copy a file from one to puter to another, I get error message on the xLookupformulas because it adds the complete path of the 'from' puter to the formulas. (User/appdata/roaming/microsoft/addins/xlookup.xlam then will not 'Update' saying...

Simple worksheet where: Cell E6 is time in as in 7:28 AM cell formatted as h:mm Cell F6 is time out as in 4:32 PM and the cell is also formatted as h:mm Cell G6 is total using formula =IF(F6<E6,F6+1,F6)-E6 That works fine giving 9:04 My Problem is when I try to add say five days of the...

=IF(ISNUMBER(F9),IF(SUM(F9-E9)>=0,ROUNDUP(SUM(F9-E9)/2,0)+E9,IF(SUM(E9-F9)>1,(E9-1),E9))) This formula is in cell G9. It works fine except if there is no entry in cell F9, it displays the word FALSE. I want it to remain blank until there is an entry into F9. I have tried incorporating the ""...

Wondering if this is possible in Excel. I have 40 golfers. Want to randomly pair them (2 man teams) each day for 3 days but without repeat pairs. If possible can someone put me on the right track ? Thanks

In the attached file, tab(sheet 2016) column O. Is there a way I can rank the teams by team total and keep the overall format of the sheet ?

I hate to ask this because I know it is a simple solution that I just can't stumble on, but would someone mind telling me how to combine 3 queries into one giving three result columns instead of one ? All 3 are the same except the 'day'. Lists players and the average score each day Friday...

Could some tell me why I get 26,000+ years from this formula using a date of 11/25/1947 in cell a14 ? Months and days 'seem' to work. I am trying to calculate years, months, and days from a birthdate and using Today(). I am trying the long way to use in both Excel and Open Office and OO does not...

Is there a way to calculate number of weeks from a begin date and end date ? Example. Cell D5 has a begin date and cell E5 has an end date. In cell G20, I would like to show the number of weeks (and left over days) from those dates if that is possible.

In F13, I have this --> =IF(ISBLANK(E13),"",IF(SUM(E13-D13)>=0,ROUNDUP(SUM(E13-D13)/2,0)+D13,ROUNDDOWN(SUM(E13-D13)/2,0)+D13)) In K13 I have this --> =IF(ISBLANK(E13),"0",MEDIAN(4,-4,E13-D13)) Lastly in N13 I have this --> =IF(AND(ISBLANK(E13),ISBLANK(E14)),"",K13+L13+M13+K14+L14+M14) My...

Working on a golf points (instead of stroke) calculator. I have run into a brick wall on trying to: Scenario: If I need 20 points on a given round and I pull 23, I am plus 3. I need to round that plus 3 up to 4, take half and add to the 20 needed which will make the next round needed 22. On...

I have a field ldate (lesson date). Next to that, I have a field ldow (lesson day of week). I am trying to return the day of week in that field based on the ldate then save both to the table. ex. I input 01/14/2012 in the ldate field I want it to return Sat in the ldow field. Is that possible ...

Would someone tell me why the top part of this code doesn't do anything ? It executes the code after the else I have tried variations of the If Date syntax but it seems to ignore it Private Sub Form_Open(Cancel As Integer) If Date = 2242011 Then MsgBox "It is Feb 24, 2011"...

Anyone know how I can have an Access program disable itself automatically on a given date without damaging the data but still be able to open (by programmer) and enable it ?

This query lists all customers and their service amounts that are greater than a prompted parameter input. As in, I input 22, it lists all customers with service charge amounts greater than 22. I would like to add a column in a report that shows the difference in the SrvAmt and the input amount...

Is there a way to prevent data in a split DB from being imported by another program ?

I can't think of a better place to ask or better people to ask, but: I am using Office 2003 Pro. Since I have went to Win 7, Thinking of changing to 2007 or 2010 Is either worth the change as far as Access goes ? Would appreciate opinions.

I have a split DB and have it set to compact on exit. However, I just noticed it does not compact the data file. Is there a way to do both on close ?

When inputting information into multiple tables, I assume, which I hate to do, the best way is to use append query. If this is correct, is there a limit to how many tables can be appended to from an append query in a single form ?