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 =)

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...

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...

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...

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...

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...

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...