hardware

  1. J

    Mailmerge data layout - vertical or horizontal

    (Apologies of this needs to be in a Word forum, but it is 50% Excel related!) I have some data that I use to create a mailmerge, and in its raw form, the data looks like this: <tbody> hardware support price Alpha a1 £11 Alpha a2 £12 Bravo b1 £22 Bravo b2 £24 Bravo b3 £26 Charlie...
  2. T

    INDEX MATCH Query

    Hi I think this may be an Index/Match formula but not 100% Trying to work out a cost based on two factors as displayed below. <tbody> Hardware Category Berlin Amsterdam London Frankfurt Copenhagen Lisbon Madrid Barcelona 1 £175 £175 £35 £175 £135 £235 £235 £235 2 £185...
  3. N

    Array Formula for unique counts

    I have column A with values such as col A col B ----------- ------------- Software SO1 Media ME1 Hardware HA1 Hardware HA2 Software SO2 Media ME2 Hardware HA3 Software SO3 I am looking to add a...
  4. B

    Complicated IF AND OR statement

    Hello, I am trying to create a rule for capitalizing the correct value of IT assets for accurate accounting and depreciation purposes. Here are the conditions: IF the asset and is a composite asset meaning built from multiple pieces AND/OR: <tbody> Hardware less than $5,000 INCLUDE VALUE...
  5. S

    What processor do and RAM do you need?

    Hi folks, I'm looking to buy a SurfaceBook 2 for home and working from home. My IT person at work said I'd need at least an i7 and 16MB of RAM. A SB2 with those options is *really* pricey. I'm wondering if I can get by with an i5 and 8MB. For background, I work with Excel files that are...
  6. A

    Slow Excel Performance

    Dears, We have a big excel file, 150MB in Excel Binary Format (XLSB), i had a big issue with the performance of the file, operations on the file take a lot of time, we have some pivot charts for some graphical representation, but the main sheet we have, is the big number of records, we have...
  7. S

    Running Inventory

    I am creating a running inventory sheet. In most of the cells, there will be a serial number that I need to count as -1 from inventory count. In stock will be calculated separately, I need to continually subtract from In Stock to get my Available total. What formula should I use? In example...
  8. J

    Evaluating a criteria based on grouping in another column

    am trying to get a formula that searches within a sales order (column A) and tells me if that sales order contains SECT or not (column C). <tbody> SALES ORDER CUSTOMER PLANNER 332456 HOME DEPOT SECT 332456 HOME DEPOT GATE 332550 THE FENCE MAKER POST 332550 THE FENCE MAKER GATE...
  9. P

    Extracting text based on two conditions and large within group of data

    hi there - am working on Sales table with COGS data within as below here; am trying to get Brand name with High sales value for INV & where Sales value is "zero" & Purchase is "greater" than "Zero" i.e. line 3 should show "Brand" as "ABC" instead of "Misc - HW" <tbody> Type Date Num Item...
  10. 1

    Hardware priority for Excel?

    Hello, excellers =] This is my first post, and happy to join the vibrant community! I recently build a 775 socket desktop with modified 771 xeon e5450 cpu. With 16g ddr3 ram and ssd, it cost me about $200, including a $50 motherboard from the age. Before this, I used an ivy-bridge i5 desktop...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top