Search results

Hello All, can someone please give me a simple explination how the two are different? It would be greatly appriciated!! Thank you =)

Hello, I was wondering if anyone knows why this is occuring: I have an excel file that I uploaded to SharePoint that contains data validation lists. When users open the file, the drop downs no longer appear in the cells.... Thank you =)

Hi kchiba and Faseeh Thank you so much for your responses. Both ways work well! :D Shine On, Sprlvlyldy

Hi Bobhc, I actually did use the search box but was not really able to find what I was looking for. I apologize if my question upset you...and thank you for the link, but I am looking to create a Pivot Table to display the totals of unique values without removing duplicates from the worksheet.

Howdy, I have a large file, 66958 rows to be exact. Within that worksheet, there are duplicates. Is there a way to create a Pivot table that will not be all the rows, but just the unique values and not have to delete the duplicates from the worksheet? Thank you in advance! =D

Hi All, I am trying to do a simple V lookup and I am getting an #N/A returned with an error that says 'a value is not available to the formula or function.' So I go into calculation steps and step in. It says the cell currently beiing evaluated contains a constant. I have no idea what that...

Hi SirJB7, sorry my knickname confuses your fingers....lol It worked! AWESOME and thank you so much!! =)

Hi SirJB7 thanks for your response...I am new to all this neat excel stuff. I go to the conditional formatting in the Styles section under the home tab, correct? If so, where would I enter the formula that you provided? Thank you again!!

Ok, I don't know if there is a way to do this, but I figure if there is, someone here would know! I have a very large excel file, 650388 rows to be exact. Column A contains numbers. Is there a way to check and see or somehow indicate on the spreadsheet where the numbers aren't consecutive...

ooooooooooh I get it now. Thank you!

This shows the ones that are greater/less than, but is there a way to also put in the formula to show it as true if they are also equal dates?

Hi All, I know this should be really simple, but for whatever reason I can't seem to get it. I have two columns with dates. One column is Occurence Date (column C) and the other is Alert Date (column D). I need to show if the dates in column C are equal to or less than the dates in column D...

yes, and they are merged with other cells, so I don't know if that makes a difference. So I merged cells B2:G2, B3:G3 and B4:G4.

Hi, this site has definately been my go to site. I am so new to VBA. I have been trying to figure this out for the past couple hours and decided to give in and ask the great minds on here. I have a command button on the bottom of my excel sheet for printing. I do not want the user to be able...

Thank you for your suggestions. I went ahead and locked the cells and protected the worksheet and that works exactly how I need it to! =)

Hello, I only want to allow users to use the the tab key to go a certain amount of cells in a row. When they reach the end point and hit the tab key, is there a way to have the cursor automatically move to the next row below? Also, is there a way to prevent a user from tabbing forward if the...

Awesome it finally worked!!!! Thank you for your help!!

Thank you for your response, unfortunately I am not very familiar yet with creating macros, and when I pasted this in to create the macro, I get an error that says: Compile Error Method or data member not found and when I click OK, the word Shapes in If Sheet1.Shapes is highlighted in blue...

First and formost this site ROCKS! I am familiar with the basics of Excel, but not with how creative you can really be and I am learning a lot from this site! So Thank you!! Long story short, I am creating a "form" that will be completed and routed for signature. The problem is, when manually...