Search results for query: *

Tried to bump this old thread thread68-679182 but it is now closed...only 5 years old :) Is it possible to use the wildcard in an IF formula? For instance, I have a spreadsheet with text and numbers in the cells, the number of characters varies in the cells so a left, right or mid is out. I...

Is it possible to count the number of occurrences in between a date range if you have a unique identifier? I can use the SumProduct function to sum the date but I want to count the # of times a 'Store Number' appears in my data dump. Any help would be appreciated. Or just I just try an IF...

I have a list where the unique identifying number repeats several times because of multiple items (different sku numbers). This data also contains an inventory column, sku count column, and variance column. Other than a pivot table, is there another way where I could rank the variance of each...

I apologize in advance for the lame question. I have one table where I want to count the number of transactions over certain amounts (25, 50, 75). I have a query that is counting the TOTAL number of Transactions but when I enter ">25" in the criteria box, I receive a "Data Type Mismatch in...

I have a form (frmDates) that is linked to an Excel file that is updated every week. Eventually this will be a sub form that will populate three different dates. However, when I view the form, it is showing "#Num" instead of the MM/DD/YYYY that is on the Excel file. I have doubled checked...

Good Afternoon, I recently changed my DSL connection from USB to Ethernet to I could add a router to an old desktop. When I first made the switch I released the USB IP and then selected the Ethernet card in the winipcf window. It worked great and faster than ever. However, after I shut down...

I have two sheets of data, each containing a look up value (Item #). However, Item #1 maybe on sheet1 and not sheet2 or both. I would like to create a formula that looks for the item number and returns the sum (Cost) of both sheets. I could combine the two and create a pivot but would rather...

Good Afternoon, I am attempting to create a simple DB with two tables. The first table (tblStoreList) contains the following fields: Store #, Date, Item, Quantity, SKU, Description, Cost, Comments The second table (tblRadioInfo) contains the following fields: Item #, Item, SKU...

Everytime I attampt to delete an email in Outlook Express I receive the following error: Msimn has caused an error in DIRECTDB.DLL. Msimn will now close. If you continue to experience problems, try restarting your computer. However, I am able to send and receive emails. PLease advise.

I am attempting to have the marco go to the end of the data PLUS one row. The current line of code is: Selection.End(x1Down).Select Any ideas or thoughts why this is not working? Thanks

I have a summary tab with subtotals in every 5th cell. I have a very simple formula of: =rank(I20,$I$20,$I$25,$I$30,$I$35,$I$40,$I$45,1) And I keep getting an error, will Excel not allow a user to use the rank formula in non adjacent cells? Thanks,

I just got a new lap top at work and it is equiped with XP and Excel 2002. If I reference any active pivot tables in a formula, the formula bar shows "=GETPIVOTDATA("Name",$A$3)". In Excel 2000, the formula bar would simply show "=B11". Any idea how to switch the view in 2002 to show a simple...

I had a db replicated with the Design Master on my C: drive and the replicate on the network. Being the genius that I am, I managed to delete the Design Master. I used the Tools- Replication - Recover Design Master and it recovered the replicated db as Design Master. So now there is just...

I have dates in column J, in Column K I just want to return the month. However, I do not have dates is every row. So I attempted to use a is-iserror.... Simple enough or so I thought. Below is my formula. =IF(ISERROR(MONTH(J19)),"",(MONTH(J19))) It seems to work fine, except it is placing...

Once a user has selected the “Do not Remind Me Again” option when the Browser prompts to remember password, is it possible to switch the prompt back on? I have a new colleague on an old pc where the previous user disabled this option and now she has to type in passwords 50 times a day bc, it...