hardware

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

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

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

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

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

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

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

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

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

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