Currently I'm creating a database for models and I want some automation in it.

I know how to do some conditional formatting but not that extensive.

So what I want to do:

The models are divided in 2 groups; fashion and commercial. They belong to one group depending on their height.

And the height requirement is different for each gender.

So basicly:

If a model is female and 175 or heigher, I want her length to be green and her group to be Fashion

If a model is female and below 175, I want her length to be regular and her group to be Commercial

If a model is male and 184 or heigher, I want his length to be green and his group to be Fashion

If a model is male and below 184, I want his length to be regular and his group to be Commercial.

So; I want the cell of the height to change depending on it's own value, which is above 175 for female and 184 for male but also on the value of the gender. So that it wouldn't turn green for males on 175.

And I want the cell of the group to change the name depending on wether the background of the height is green, if that's even possible.

Could any of you help me out?

The colums; B is for the gender, J is for the height and V is the group

]]>I know how to do some conditional formatting but not that extensive.

So what I want to do:

The models are divided in 2 groups; fashion and commercial. They belong to one group depending on their height.

And the height requirement is different for each gender.

So basicly:

If a model is female and 175 or heigher, I want her length to be green and her group to be Fashion

If a model is female and below 175, I want her length to be regular and her group to be Commercial

If a model is male and 184 or heigher, I want his length to be green and his group to be Fashion

If a model is male and below 184, I want his length to be regular and his group to be Commercial.

So; I want the cell of the height to change depending on it's own value, which is above 175 for female and 184 for male but also on the value of the gender. So that it wouldn't turn green for males on 175.

And I want the cell of the group to change the name depending on wether the background of the height is green, if that's even possible.

Could any of you help me out?

The colums; B is for the gender, J is for the height and V is the group

Hi Forum,

I wanted to extract data from "Miami" and "New York" tables and populate the "Miami + New York" table.

Would there be any automated way of doing this such as vlookup because I have several hundreds of records in each "Miami" and "New York" tables.? ?

Thanks

Mirisa

I wanted to extract data from "Miami" and "New York" tables and populate the "Miami + New York" table.

Would there be any automated way of doing this such as vlookup because I have several hundreds of records in each "Miami" and "New York" tables.? ?

Thanks

Mirisa

Hi everyone :)

Sorry I'm not up on the terminology of excel and the formulas.

I am making a spreadsheet that will track measurements for a gym trainer who wants to track their clients monthly measurements. I need the formula to show a total loss.

So I will enter a number for January, subtract Februarys measurement from January to get the total loss.

But now I'm lost. To show the total loss for March I need the formula to recognize that I now have to subtract March's Measurement from January. Februarys measurement is no longer valid.

Any idea how to do this?

Sorry I'm not up on the terminology of excel and the formulas.

I am making a spreadsheet that will track measurements for a gym trainer who wants to track their clients monthly measurements. I need the formula to show a total loss.

So I will enter a number for January, subtract Februarys measurement from January to get the total loss.

But now I'm lost. To show the total loss for March I need the formula to recognize that I now have to subtract March's Measurement from January. Februarys measurement is no longer valid.

Any idea how to do this?

Don't know what happened. Just all of a sudden I open up my file, which is for work and has a lot of data, and it was corrupt.

I'm currently going through all the steps I've found so far, like the office repair process, "open and repair", moving the file to a different location, reopening file after changing calculations to manual, linking to the corrupt workbook from another workbook... All failed.

The only other thing I've not tried that I've read about so far is installing some feature that will allow you to open it with Word. When I tried all characters were the same. Otherwise I read you can run a macro but I would leave that for last as I've zero experience with those but I'll do whatever it takes. I just need some pointers. Anyone? Thanks

]]>I'm currently going through all the steps I've found so far, like the office repair process, "open and repair", moving the file to a different location, reopening file after changing calculations to manual, linking to the corrupt workbook from another workbook... All failed.

The only other thing I've not tried that I've read about so far is installing some feature that will allow you to open it with Word. When I tried all characters were the same. Otherwise I read you can run a macro but I would leave that for last as I've zero experience with those but I'll do whatever it takes. I just need some pointers. Anyone? Thanks

Hi There

Please help me custom format the attached file - I have tried to create a custom number format which I can drag down (i.e. paste special - format) but for some reason both Cells A3 & A4 do not display the "Ft (short for feet) correctly even though the final sum total (cell A5) does display correctly. Any help would be appreciated - thanks!

Regards

SilverBullet17

Please help me custom format the attached file - I have tried to create a custom number format which I can drag down (i.e. paste special - format) but for some reason both Cells A3 & A4 do not display the "Ft (short for feet) correctly even though the final sum total (cell A5) does display correctly. Any help would be appreciated - thanks!

Regards

SilverBullet17

Hello everyone, I am new here to this forum! First post:) . Here is the issue I am having that I need help with: I have 4 columns with many, many rows of data. I am trying to figure out a way to get the numbers in 3 columns to auto update when I change the number in the first column. For example, if I have A1=1, B1=2, C1=3, D1=4, and I change A1 from 1 to a 2, I would like the remaining three columns to auto update(B1=4, C1=6, D1=8). Or for another example, if I changed A1 from 1 to .5, I would want the remaining three columns to auto update to B1=1, C1=1.5, D1=2. How do I go about doing this, do I need to utilize a formula, function, or something else?? Also, if there is a solution, can I mass apply it to all of the other rows of data I have? So that, for example, cells B2 C2 D2 would change if I changed A2, and B3 C3 D3 would change with A3 and so on...?? Thanks!!

]]>Is there a way in Excel 2016 for Mac to view pages side by down and then side by side so if I were to hypothetically insert a row into a page I view on the right it has zero impact on the page on the left because technically it's underneath it though I am just viewing them side by side?

]]>Hello all,

I just registered to this forum, because i need some help with one excel invoice. I know this might be a stupid question/easy question, but anyway, here it is:

if E5 contains the text "today", then E4 should contains number "256"

if E5 contains the text "tomorrow", then E4 should contains number "100"

if E5 contains the text "airplaine", then E4 should contains number "99"

Let's say that

256 = M10

100 = M11

99 = M12

I hope i made myself understood 😏

Thank you in advance.

]]>I just registered to this forum, because i need some help with one excel invoice. I know this might be a stupid question/easy question, but anyway, here it is:

if E5 contains the text "today", then E4 should contains number "256"

if E5 contains the text "tomorrow", then E4 should contains number "100"

if E5 contains the text "airplaine", then E4 should contains number "99"

Let's say that

256 = M10

100 = M11

99 = M12

I hope i made myself understood 😏

Thank you in advance.

Hello all,

I just registered to this forum, because i need some help with one excel invoice. I know this might be a stupid question/easy question, but anyway, here it is:

if E5 contains the text "today", then E4 should contains number "256"

if E5 contains the text "tomorrow", then E4 should contains number "100"

if E5 contains the text "airplaine", then E4 should contains number "99"

Let's say that

256 = M10

100 = M11

99 = M12

I hope i made myself understood

Thank you in advance.

]]>I just registered to this forum, because i need some help with one excel invoice. I know this might be a stupid question/easy question, but anyway, here it is:

if E5 contains the text "today", then E4 should contains number "256"

if E5 contains the text "tomorrow", then E4 should contains number "100"

if E5 contains the text "airplaine", then E4 should contains number "99"

Let's say that

256 = M10

100 = M11

99 = M12

I hope i made myself understood

Thank you in advance.

Hi All,

As I was working on one sheet, which contains data in group of 2,separated by one single blank row, my task is to find out all similar groups from the first column and put it together.

For example the first pair data I have in first row as "jyoti" and in 2nd row I have "kumari" now in the same sheet and in the first column somewhere I will be having "kumari" and "singh" in a pair and "jyoti" "neer" in another pair.

Now all I need is to group this 3 pair together which will give me a result of a group jyoti, Kumari, Singh, neer all in different line but together.

As, till now I am doing it manually, so any idea Wil be a great help

As I was working on one sheet, which contains data in group of 2,separated by one single blank row, my task is to find out all similar groups from the first column and put it together.

For example the first pair data I have in first row as "jyoti" and in 2nd row I have "kumari" now in the same sheet and in the first column somewhere I will be having "kumari" and "singh" in a pair and "jyoti" "neer" in another pair.

Now all I need is to group this 3 pair together which will give me a result of a group jyoti, Kumari, Singh, neer all in different line but together.

As, till now I am doing it manually, so any idea Wil be a great help

Hi All

The attached spreadsheet has been used before it was due to be and I think inadvertently a formula has been altered maybe. How it should work is information entered into the ALL section will then filter through to the relevant month sections based on the date entered in column AC. It was working but now I can't seem to get anything to go through other then row 3. I'm pretty sure it's something really silly but I cannot see it.

Can anyone assist me?

The attached spreadsheet has been used before it was due to be and I think inadvertently a formula has been altered maybe. How it should work is information entered into the ALL section will then filter through to the relevant month sections based on the date entered in column AC. It was working but now I can't seem to get anything to go through other then row 3. I'm pretty sure it's something really silly but I cannot see it.

Can anyone assist me?

I made a simple production calculator for different tasks performed during a shift. The problem is it is very ugly and not user friendly. Any help to make this easier on the eyes, combine to one page, and more easy to use would be very much appreciated. Thank you.

Sorry for the trouble, got the project attached now.

Removed grey.

Sorry for the trouble, got the project attached now.

Removed grey.

Hi all. Sorry if this is a basic question but my mind has gone blank!

I have a table. It doesn't matter how many rows or columns. I want to enter a value of "Y" in cell A1, and when I do, I want the rest of the cells in that row of the table, including A1, to conditionally format to a green fill.

Can anyone help? I know that this is a basic format but, honestly, it is driving me insane!

Thanks.

]]>I have a table. It doesn't matter how many rows or columns. I want to enter a value of "Y" in cell A1, and when I do, I want the rest of the cells in that row of the table, including A1, to conditionally format to a green fill.

Can anyone help? I know that this is a basic format but, honestly, it is driving me insane!

Thanks.

Would like to have a cell calculate how much bonus money someone gets based on how efficient they did their job.

Lets say the goal hours to complete a job is 100.

If they complete the job in 100 hours no money goes in the bonus pool

For every hour they can go under the 100 hr goal I would like to add 10.00 to the bonus pool.

For every hour they go over the 100 hr goal I would like to subtract 10.00 from the bonus pool.

Any ideas how to put this together?

Thanks in advance!

]]>Lets say the goal hours to complete a job is 100.

If they complete the job in 100 hours no money goes in the bonus pool

For every hour they can go under the 100 hr goal I would like to add 10.00 to the bonus pool.

For every hour they go over the 100 hr goal I would like to subtract 10.00 from the bonus pool.

Any ideas how to put this together?

Thanks in advance!

I have a sheet that contains product descriptions starting with a brand name. I need to copy the first word from each row & deposit it into another column in the same row. Can this be done?

Here is an example, where i have manually copied the first two rows data into the second column:

Here is an example, where i have manually copied the first two rows data into the second column: