Good afternoon - I'm stumped, obviously or otherwise I wouldn't be asking this question. I've attempted to attach an XLSX file for further clarification.

In Table 1 (in the attached) I track record changes for a specific period - one record per row, multiple columns.

In Table 2 (in the attached) I track each period but would like to look up "Other Stuff" from Table 1.

I hope this makes sense - I've already written "For example" and deleted it about 20 times, really - the attached spreadsheet has the best example I can think of.

Thanks for any/all help.

In Table 1 (in the attached) I track record changes for a specific period - one record per row, multiple columns.

In Table 2 (in the attached) I track each period but would like to look up "Other Stuff" from Table 1.

I hope this makes sense - I've already written "For example" and deleted it about 20 times, really - the attached spreadsheet has the best example I can think of.

Thanks for any/all help.

Hi guys

this is my 1st post, ive always loved excel and belive im ok at it for self learnt but this one is testing me so im calling on some assistance if at all possible

I cannot actually upload my own spreadsheet as its over 1000KB so ive deleted most of it a made a mini version attached

what im looking for help with is:

1.) if any product code is selected on the kit sheet (Green tab) the same code on the catalogue (Yellow tab) would highlight so we know at a glance which products are being used and which are surplus

, one other issue is that the tabs have some code to change the name automatically to marry up to the kit name choosen

2.) as we have so many products in our main spreadsheet (not Mini) you will see the data validation drop down on the (Green Tab) are very long, i wondering if there is a way to hide some of the cells in the catalogue that also reduces the amount avaiable in the drop down list making it easier & quicker to make a selection?

or

is there a way to instead of drop down to start typing "Running outlet" for example in the cell and it only shows any line with that selected text to choose from?

any help be much appriciated

this is my 1st post, ive always loved excel and belive im ok at it for self learnt but this one is testing me so im calling on some assistance if at all possible

I cannot actually upload my own spreadsheet as its over 1000KB so ive deleted most of it a made a mini version attached

what im looking for help with is:

1.) if any product code is selected on the kit sheet (Green tab) the same code on the catalogue (Yellow tab) would highlight so we know at a glance which products are being used and which are surplus

, one other issue is that the tabs have some code to change the name automatically to marry up to the kit name choosen

2.) as we have so many products in our main spreadsheet (not Mini) you will see the data validation drop down on the (Green Tab) are very long, i wondering if there is a way to hide some of the cells in the catalogue that also reduces the amount avaiable in the drop down list making it easier & quicker to make a selection?

or

is there a way to instead of drop down to start typing "Running outlet" for example in the cell and it only shows any line with that selected text to choose from?

any help be much appriciated

Greetings, Gurus.

I'm trying to create a Formula that would identify with a "Y" or "N" whether a row of 4 cells has 3 or more unique numbers. In the sample attached I have manually entered the results I would like to achieve via formula. If the 4 cells contain on 2 or less unique numbers I would like to enter a "N", if 3 or more unique numbers I would like to enter a "Y".

Thanks in advance for any help you can offer.

I'm trying to create a Formula that would identify with a "Y" or "N" whether a row of 4 cells has 3 or more unique numbers. In the sample attached I have manually entered the results I would like to achieve via formula. If the 4 cells contain on 2 or less unique numbers I would like to enter a "N", if 3 or more unique numbers I would like to enter a "Y".

Thanks in advance for any help you can offer.

I'm trying to formulate some basic metric conversions in Excel. Just starting off, and I'm already stuck.

To convert kilograms to pounds, you multiply kilograms by 2.20, which equals 4.40, but actually it should be 4 pounds and 6.55 ounces. How can I create a formula that will give such results? There's 16 ounces in a pound, so I need to figure out how to equate anything to the right of the decimal to ounces.

Any suggestions?

]]>To convert kilograms to pounds, you multiply kilograms by 2.20, which equals 4.40, but actually it should be 4 pounds and 6.55 ounces. How can I create a formula that will give such results? There's 16 ounces in a pound, so I need to figure out how to equate anything to the right of the decimal to ounces.

Any suggestions?

Hi All

I am in need of help with a formula. I am trying to count the number of instances for each of the items in four individual 'Regional' tables and have that amount added up for an 'All Regions' Total.

Using the category 3rd Party Host Connection Problem' in the below attachment as an exxample, I want to add up the number of times it occurs in each of the Regional tables (columns B, G, L and Q) and input that value into cell W32. A simple sum equation gets the desired result, but that presents a problem when I want to filter the data on that table and reorder from smallest to largest value for the purpose of putting into a chart. The data gets reordered but the category names stay in the same order (column U) distorting my data on the chart.

The formula I tried (unsuccessfully) is as follows:

=COUNTIFS($b$31:$b$40, U32, $g$31:$g$40, U32, $l$31:$l$40, U32, $q$31:$q$40, U32)

Any help would be much appreciated! I hope that my description was clear -- please feel free to reach out with any questions.

I have attached the spreadsheet below. The tab I am referring to is 'Excel Templates'.

I am in need of help with a formula. I am trying to count the number of instances for each of the items in four individual 'Regional' tables and have that amount added up for an 'All Regions' Total.

Using the category 3rd Party Host Connection Problem' in the below attachment as an exxample, I want to add up the number of times it occurs in each of the Regional tables (columns B, G, L and Q) and input that value into cell W32. A simple sum equation gets the desired result, but that presents a problem when I want to filter the data on that table and reorder from smallest to largest value for the purpose of putting into a chart. The data gets reordered but the category names stay in the same order (column U) distorting my data on the chart.

The formula I tried (unsuccessfully) is as follows:

=COUNTIFS($b$31:$b$40, U32, $g$31:$g$40, U32, $l$31:$l$40, U32, $q$31:$q$40, U32)

Any help would be much appreciated! I hope that my description was clear -- please feel free to reach out with any questions.

I have attached the spreadsheet below. The tab I am referring to is 'Excel Templates'.

I have an array in cells BN:CA - - each cell contains 120.12

The array total is in CB - formatted to 3 decimal places

Totaled, the ARRAY shows 1681.680 - - i want it to show 1680.168

but the decimals are overflowing.

Here is the array - - {=SUM(LARGE($BN9:$CA9,ROW(INDIRECT(1&":"&$C$2))))}

I also tried adding a ROUND....,3 to it...but couldn't get that to work either.

ideas?

]]>The array total is in CB - formatted to 3 decimal places

Totaled, the ARRAY shows 1681.680 - - i want it to show 1680.168

but the decimals are overflowing.

Here is the array - - {=SUM(LARGE($BN9:$CA9,ROW(INDIRECT(1&":"&$C$2))))}

I also tried adding a ROUND....,3 to it...but couldn't get that to work either.

ideas?

Hello,

I can't seem to find an answer, but it could be that I'm asking the wrong questions.

I have some data with various items that have a cost, and a numeric value. What I'm trying to do is extract a list of items to buy up to a set limit that will produce the maximum combined value. I've managed to get as far as sorting the items based on value/cost, and stopping the list when I can't afford the next item(I left that out for now for clarity), but I can't seem to figure out how to continue past that to the next item I could still afford?

For example in the attached you will see that while I can't afford Item I, I should still be able to buy Item B.

Would someone please help point me in the right direction?

Thanks,

B

I can't seem to find an answer, but it could be that I'm asking the wrong questions.

I have some data with various items that have a cost, and a numeric value. What I'm trying to do is extract a list of items to buy up to a set limit that will produce the maximum combined value. I've managed to get as far as sorting the items based on value/cost, and stopping the list when I can't afford the next item(I left that out for now for clarity), but I can't seem to figure out how to continue past that to the next item I could still afford?

For example in the attached you will see that while I can't afford Item I, I should still be able to buy Item B.

Would someone please help point me in the right direction?

Thanks,

B

Hello,

Here is the function that I require:

I have a large set of data (non recurring numbers), which have different trial numbers at the end of each data point from 1-4.

So something like this:

asdfg-1

nbvcf-2

rtyui-2

cvbjs-4

oiuyt-3

mnbvc-1

zxcfg-2

piuye-4

I need to take the last number in each data set and put it into a new column. So something like this:

asdfg-1.... 1

nbvcf-2.... 2

rtyui-2..... 2

cvbjs-4.... 4

oiuyt-3.... 3

mnbvc-1.. 1

zxcfg-2.... 2

piuye-4.... 4

I have attached an excel file with the same information.

Hopefully you guys can help me with this! :)

Thank you!

Here is the function that I require:

I have a large set of data (non recurring numbers), which have different trial numbers at the end of each data point from 1-4.

So something like this:

asdfg-1

nbvcf-2

rtyui-2

cvbjs-4

oiuyt-3

mnbvc-1

zxcfg-2

piuye-4

I need to take the last number in each data set and put it into a new column. So something like this:

asdfg-1.... 1

nbvcf-2.... 2

rtyui-2..... 2

cvbjs-4.... 4

oiuyt-3.... 3

mnbvc-1.. 1

zxcfg-2.... 2

piuye-4.... 4

I have attached an excel file with the same information.

Hopefully you guys can help me with this! :)

Thank you!

Dear Friends,

I create formula there is #VALUE! error.

I use SUMPRODUCT. Details I put on attached file.

Thank you in advance for your help

Regards,

Wie

I create formula there is #VALUE! error.

I use SUMPRODUCT. Details I put on attached file.

Thank you in advance for your help

Regards,

Wie

I'm trying to calculate summary from data it's working fine with SUMIFS but it will take me longs to edit each Range in a single Row. A example of summary including data and preconfig SUMIFS attached and everything is working fine but I have bunch of products to list and it will take long, I think there is a possibility to use VLOOKUP with SUMIFS.

Can't I just use to define name for F:S on items sold sheet and in summary sheet i can have results with company name & datawise?

Looking for a solution.

Can't I just use to define name for F:S on items sold sheet and in summary sheet i can have results with company name & datawise?

Looking for a solution.

I am trying to combine the VLookup and HLookup functions.... I have a workbook with 3 tabs.... Tab1 is a table with 3 columns and Tab3 is a table in which I'm trying to import information from Tab1. Basically I'm trying to do this:

If information in cells A1+B1 (combined) on Tab1 equal the combination info in cells A3 and C2 on Tab3, then cell C3 is equal to what's in cell C2 on Tab1.

I tried to do an attachment but of coarse it wont' let me.... I'm pretty sure I'm on the right track with combining the lookup functions but just cannot seem to complete it.

Please help!!!!

If information in cells A1+B1 (combined) on Tab1 equal the combination info in cells A3 and C2 on Tab3, then cell C3 is equal to what's in cell C2 on Tab1.

I tried to do an attachment but of coarse it wont' let me.... I'm pretty sure I'm on the right track with combining the lookup functions but just cannot seem to complete it.

Please help!!!!

Column A has start dates, column B has completion dates (some cells empty)

Need a summary table that calculates:

Projects finished within 1 month:

Within 2 months:

I tried =COUNTIFS(B5:B7,("<"&((A5:A7)+30))) but no luck! It works for just one sell, but not a range unfortunately.

Thank you for any help!

]]>Need a summary table that calculates:

Projects finished within 1 month:

Within 2 months:

I tried =COUNTIFS(B5:B7,("<"&((A5:A7)+30))) but no luck! It works for just one sell, but not a range unfortunately.

Thank you for any help!

Hello,

I have been trying to transpose a bunch of data and cant seem to get it working properly.

this is the raw data sheet 1.

COL A | COL W | COL X | COL Y | COL Z |

Item1 | result1 | result2 | result3 | result4 |

Item2 | result1 | result2 | result3 | result4 |

I need to transpose to this on a different sheet 2:

COL A | COL B

Item1 | result1

Item1 | result2

Item1 | result3

Item1 | result4

Item2 | result1

Item2 | result2

Item2 | result3

Item2 | result4

Transpose will not allow me to repeat the item number the 4x's down.

]]>I have been trying to transpose a bunch of data and cant seem to get it working properly.

this is the raw data sheet 1.

COL A | COL W | COL X | COL Y | COL Z |

Item1 | result1 | result2 | result3 | result4 |

Item2 | result1 | result2 | result3 | result4 |

I need to transpose to this on a different sheet 2:

COL A | COL B

Item1 | result1

Item1 | result2

Item1 | result3

Item1 | result4

Item2 | result1

Item2 | result2

Item2 | result3

Item2 | result4

Transpose will not allow me to repeat the item number the 4x's down.

The formula should do the following:

ORIGIN --------- EXPECTED

cell B3 -------- cell J3

D11 -------- 11

HEP100 -------- 100

L70 * 7 -------- 70

L70 * 123 ------ 70

PL10 * 250----- 10

I hope you can help.

Thank you.

Marco

]]>ORIGIN --------- EXPECTED

cell B3 -------- cell J3

D11 -------- 11

HEP100 -------- 100

L70 * 7 -------- 70

L70 * 123 ------ 70

PL10 * 250----- 10

I hope you can help.

Thank you.

Marco

I am attempting to use Solver to calculate Rates and Hours based upon a total amount when some of the information is know. The issue I'm running into is that the Hours results (which are variable cells) must be limited to the tenth's place. However, solver is returning results well beyond that. Any help in setting up the constraints for this problem would be much appreciated.

Screenshot.PNG

]]>Screenshot.PNG