excel help

I have two tables pictured below: Table 1 <tbody> Columns Rows A B C D E F G H I J K L M N O P Q 1 2 Day of month 18 19 20 21 22 23 24 25 26 27 28 1 2 3 4 3 Date 2/18/2015 2/19/2015 2/20/2015 2/21/2015 2/22/2015 2/23/2015 2/24/2015...

Hi, my problem is I have a large database and need to see if 2 rows match Anywhere in the database. HOWEVER, say there are 15 columns, I only want to see if 4 specific columns match. I tried: =IF(AND(C:C=C2,E:E=E2,F:F=F2,G:G=G2),"True","False") and it seemed to be working, but after testing...

Hi So I am wondering if there is an easy way to assign preset formulas to cells having it so,,, for example I could have something like = __ +35. The goal is that when someone types a number into that cell, it will automatically add 35 to whatever number they typed in. The kicker is that I need...

Right I'm pretty much a complete novice when it comes to most of these things, so can someone provide me with a little help with creating a scrolling text bar in my spreadsheet? The info that will be included will be held, for the large part, in cell A1 so I want the ticker tape type bar to get...

Hi, I have two sets of columns that I am quite sure there is a relation between them (i.e. C12=SUM(A1:A12)*5), but yet I can't find it. Any ideas?

E4 = Dark Stone Grey - (Part ID: 4210977) I want D4 to be Dark Stone Grey

I have to calculate the idle Hrs of a working employee. Three shifts are there. Morning 7AM to 3PM Evening 3PM to 11PM Night 11 PM to 7AM. Also if overtime then shift pattern is Morning 7AM to 7PM Evening 11AM to 11PM Night 7PM to 7AM. So the in time for an employee will be based on the...

I want to sum values in column K given a range of dates from column B. Using the Sum, indirect, offset and match functions. B C D E F G H I J K <colgroup><col><col><col span="2"><col><col...

ill try to show you what I needing. column A / Column B / column c / column d / column e/ column F/ Current Employees / HIRE DATE/...

I want some vbs code on my 'Copy All' button in Email Data sheet which will do my work. Its a bit lengthy but who knows the concept will find it easy. As i am a newbie help is greatly required. I have one sheets - Sheet attached - Worksheet .xlsm - Speedy Share - upload your files here...

ok i have a sheet that looks like this <tbody> fst name lst name email bday jan feb apr may jun jul aug sep oct nov dec eric g eric86@blah 1/30 i want the email show here bob smith bob@aol.com 5/12 email </tbody> i would like to know what to put in the cells to show...

Hello, I have a column of a 1,000 randomly generated numbers where each cell shows one of two results, "1" or "-1". I want to highlight only the cells that contain the same results of 5 or more in a row. I also want to be able to highlight higher amounts like 8, 12 or 20 in a row. Currently...

Here is my situation: Data I have Data I need <tbody> 1000 1000_1 1000 1000_2 1000 1000_3 1000 1000_4 2000 2000_1 2000 2000_2 3000 3000_1 3000 3000_2 3000 3000_3 4000 4000_1 </tbody> Is there a formula to...

I'm currently making an excel file for someone. But I'm quite stuck. Here's the problem. <tbody> Size Quality order supplier order customer Stock 5X5 High 200 150 50 5X5 High 50 50 50 6X9 Low 100 25 75 5X5 High 0 50 0 </tbody> I can't find the formula for stock. It MUST check size...

Hi all, I'd like to count events between per second time intervals. For example: Time (sec) Counts 1.123 1.324 1.567 1.873 4 2.032 2.564 2.943 3 3.324 3.786 3.987 3 Any help? Thanks

Hi Guys, I hope you can help I have a list of reference numbers and I need to search these in a closed sheet and return corresponding data. It's just and INDEX & MATCH formula really but where I am falling down with this is that the data could be contained within any one of five sheets in a...

Hi Everyone, I have an excel document with multiple tabs and I would like to have the number of words in the document. I am unable to find a word count function does anyone know if it is available? thank you much and have a great day!

I have a spread sheet with multiple price classes for products.. I don't quite know how to word what exactly I'm trying to do.. Here goes ... I need to make a fuction that; if I have a price="price class" then price x "price discount" then for all the price classes. I have multiple price...

In the above image i have highlighted a cell, i have tried to customize this sheet by help of this forum to my use and i am stuck up with a new thing. Right now i have to manually insert a row into the sheet. I want to customize the sheet in such a way that when i type in data on the last cell...

I have a spreadsheet with about 1000 rows. I want to automate a process where I do the following steps: - start on a cell - copy the cell - move one cell to the right - ctrl+down - move left twice - ctrl+shft+up - move down twice (whilst still highlighting the cells) - ctrl+v Thanks for any help