help in need

I am trying to sort column u (u1:u84) and My co-worker hooked me up with this formula: =INDEX($U$2:$U$88,MATCH(ROWS($U$2:U3),COUNTIF($U$2:$U$88,"<="&$U$2:$U$88),0)) It works great, except it left out 2 names. I messed around with it and can't seem to get it. Any ideas?

I set up a spreadsheet so that you could edit a cell through a text box, the only problem is that it is limited to one column and when you select more than one cell, there is an error message. I have tried changing traget.column = 7 to target.range = ("A1:CA300") and target.adress = ("A:CA")...

I am looking to subtract 15 minutes from whatever value is in cell O2 and put that information in P2. Any help would be appreciated.

Hi, So I am creating an inventory workbook, which I receive my inventory data from a POS system that allows me to export to Excel. What I am trying to do is automate a process that compares one report to another report(ran a couple days later) and allow it to tell me which products are not in...

Hello, So I am building a sheet that is tracking inventory within totes at work. There is two macros that I need help on. So a little info before I get into the need of macros, I have a macro currently built that keeps a running list of items that is in the tote and when you push a button it...

I am currently in the process of self teaching myself how to create a multi-tab user form to help with data entry in a multi-sheet work book. I have created the user form but am struggling with the code portion of things. I have created the simple code for the cancel button to unload, and...

Current version: excel 2010 Hi to all, Currently I am trying to enhance my excel files and do update from main worksheet to duplicated worksheet. I have a main worksheet and a duplicated worksheet. The difference between the 2 worksheet are: Main worksheet has all data (at least 35 columns)...

Hi all, I'm a bit of an excel newbie and am looking for suggestions for any functions/ scripts that will help with my reformatting problem! I currently have a data set with three subheadings. (Number, Name and Fruit.) Currently each row represents a customer with an individual Number and Name...

Hey guys! I have a very important and urgent question: I am doing a quantitive content analysis of newspaper articles and have coded them all in different categories. One of the categories would be "Gender of the victim". 1=female, 2=male, 3=both, 4=not specified, 5=not applicable. In one of...

I have a data set with home listings, and I'm trying to answer the question, "For homes in inventory at the end of a given month, how many days have they been on the market on average?" Data specifics: Column A:Location Column W:List Date Column X: Close Date Column I need to average the days...

<tbody> A B C 1 20166-78 #N/A 2 20166-110 #N/A 3 20166-134 #N/A 4 20166-135 #N/A 5 20166-78 6 #N/A 7 #N/A 8 #N/A 9 #N/A 10 #N/A 11 20166-110 12 20166-134 13 20166-135 14 20167-13 15 #N/A 16 #N/A 17 12357-9 18 563263-8...

Hello guys, I am receiving error 76 when running this macro. can you help? The debug shows the problem here: Set objFolder = objFSO.GetFolder(Path) Sub All() Sheets("Dictionary").Select Range("B2:B150").Select Selection.Copy Sheets("Macro").Select Range("E11").Select...

would like to write a program with the below function If Cell ("J" i) or Cell("L" i) or Cell("N" i) in Sheet1 is not empty where i equals to any integer Then cut Cell("B" i) to Cell("O" i) in Sheet 1 to the first blank and rows after that in Sheet2 However,I don't know what should variable...

https://1drv.ms/x/s!AntW1ZrWMeX2gQNq01G4gmqqiJfO ok i am very new to excel - and it does bamboozle me a lot!!! what i am trying to do is to get the savings total to show up on the dash board just like income, expenses show up, after several hours of research i managed to get the "chart data...

Hi all, In a MASSIVE predicament and any help I can glean would be amaaaaaaazing! I am trying to do a simple SUM formula but with some cells that contain N/A and I REALLY need to find a way of the formula ignoring the N/A values / adding this as 0. I am not doing a simple '=SUM(A1:A10)' I am...

I'm not even sure where to start...this is what I'm trying to accomplish: 1. I have Worksheet 1 that has ID numbers in column A 2. I have Worksheet 2 that also has ID numbers in column A...this worksheet will have some case sensitive duplicates 3. Column B on Worksheet 1 is blank 4. Column B...

Hello. I need some assistance with my VBA code which extract numbers under certain conditions (every 2 minutes) to Sheet4 from data report in row 1 - Sheet5. I'm not very proficient with excel-vba but I'm open to suggestions and willing to learn to get this to work properly. Basically, my...

Hi Everyone, I maintain a contracts database and need to automate the total qty column. Having a really tough time getting it to automatically show those numbers. Summary: This data represents one contract (internally it is contract #18, externally, it is contract #21). It is broken down into...

I'm currently running excel 2010 on windows 8.1. I have a set of data from a txt file open in excel. I then plug that data into an equation I'm using to get my desired outcome. I then want to save only the data resulting from my equation as a tab delimited txt file. However, initially saving...

I'm currently recording a macro to to read a .txt file apply, then a function will be applied to the data and then graph it. However excel's x-axis scaling isn't as friendly to use as it appears. I need my data to begin being read at 100 centimeters but I only want the x axis to show spacing...