tech

  1. D

    Select registers without best results by category

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

    Split and change text

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

    COUNTIFS not counting

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

    Error 91 when trying to execute VBA code to find and replace data

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

    IF statements (Nested) ??

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

    Refresh All Question

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

    Crosstab, Transform, or Pivot? I'm lost...

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

    SUMIFS using conditions multiple Criteria

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

    Report Looking up Data on a different sheet with multiple requirements

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

    ComboBox1_Change - Code

    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"...
  11. W

    VLOOKUP to find repeats?

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

    array lookup calculation

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

    Sum Range based on multiple criteria

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

    Want a sum of figures when 2 rows in different worksheets are a match

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top