tech

Hi I Have a Table with a RANKING of employees like this: <tbody> NAME CATEGORY POINTS JOHN TECH 100 MARK AUDIO 99 PAUL VIDEO 99 SARAH TECH 99 ANDY TECH 99 CARL COMPUTER 99 RAY AUDIO 98 DANNY COMPUTER 98 ELLEN BAKERY 98 CHARLES BAKERY 98 FRED TECH 98 HARRY TECH 97...

I have a list of codes like this in column B: BC SB2 C08 illus brief BC SB2 C10 illus brief BC SB3 C11 illus brief BC SB2 C09 tech 1pf BC SB2 C11 tech brief AB SB2 C12 tech brief AB RT3 C01 tech brief AB SB3 C11 tech brief AB RT6 C06 illus brief ON SB6 C06 illus 2pf ON SB6 C07 illus 3pf ON SB6...

Hi I'm learning about COUNTIFS and I don't understand why this is working in one row and not another. In my first cell in question My Criteria is TECH (E4) in Ranges A2 to A20 and R(G4) is ranges B2 to B20 : I'm using =COUNTIFS($A2:$A20,$E4,$B2:$B20,G4) - and it seems to work, it counts 4...

Greetings, I'm trying to author a VBA script that will find information in column G based on criteria found in column N and replace the information in column G with the information in column O. Here's a snipit of what my worksheet looks like: <tbody> F G H N O Date Description Amount Find...

I have the following formula located in K31. =IF(L31<>"TECH","In", IF(V31>=71,"Out","In")) The manual variables are located in L and V. Here's the variable possibilities for L: TECH or Nothing. (Empty cell) TMOAM TMOOT TMPPA Here's the variable possibilities for V: =>71 If V31 => 71...

Hello, When I use the below Macro and I open any other workbook when I have my 'CS Tech Cases - Bothell' book open it will try and refresh other workbooks as well. Is there a way that I can only have it refresh the 'CS Tech Cases - Bothell' and no other workbooks opened? I thought having...

Trying to figure out the best way to turn my rows into columns, while maintaining the values and headers. Looks like a reverse crosstab query or something. I'm an amateur btw... I have about 35 columns that I want to stay the same (keep as columns), then about 50 column that have months...

Hi All, The desired output column, should be a cumulative figure of the area, the criteria being the summation should happen when the status is Completed & names are of the same tech. Example: SJR Tech = 100+200+300 = 600 If the status is Proposed or Under Construction, the output should...

I have a dataset in a different workbook, and want to pull a list of records with multiple criteria, I could do it with a macro, but wanted to see if I could make it easier using formula. My Data has the following information sample (Slimmed down) Specialist Name, Tech Supported, Activity...

Hi Guys, Dont understand what wrong here.. Private Sub ComboBox1_Change() If ComboBox1.Value = "Projects" Or ComboBox1.Value = "Process Training" Or ComboBox1.Value = "Tech Meeting" _ Or ComboBox1.Value = "Allocation" Or ComboBox1.Value = "Stake holder reviews" Or ComboBox1.Value = "Reporting"...

Below is a small sample of data that I am working with. Test parts are identified as 01-24 in column A. Location in Column B is location of test part. The tech in Column C will be S1, S2 and S3. Column D is the max value (resistance) for each Tech. Once a part is used in one test, it cannot be...

I am having troubles getting a payroll calculation formula set up. We have annual increases for employees (tenure) and I need to factor in different pay rates for different job types. Basic layout of Sheet 1 <tbody> A B C D E F 1 Employee Hours Tenure Type Income 2 AAA 3...

I cannot seem to figure this one out... tried sumifs, sumproduct, index/match. Here's what I'm trying to do: Sum data in an array that matches 3 different criteria coming from both columns and rows. Maybe it's best to illustrate. Here's a simplified version: <tbody> Company Allocation 2013...

Hi, I have different worksheets in a workbook. I need one of the worksheets to sum up the figures from the other 2 worksheets when the row inputs in those worksheets are a match. The input in one worksheet (eg row 1: Salary) may not be in the same row as worksheet 2. I tried using a if and or...