turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- 157K Members
- 2,870 Online
- 38.5K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

1574 Conversations

- Mark all as New
- Mark all as Read
- Pin this item to the top
- Subscribe
- Bookmark
- Subscribe to RSS Feed
- Invite a Friend
- Sort by Conversation Start Date

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Custom List Message Item | |
---|---|

Hi all,
I am trying to optimize some data to find a minimum amount for downtime using the excel solver function. I am creating a rotational program where 4 teams have to complete a series of tasks which have separate times required to complete. There ar ... Read More | |

Buenos días, Tengo un problema con el formato del día. Actualmente tengo un fichero que extrae el día y me devuelve en formato "ddd" con 3 caracteres (lun, mar,mié, jue, vie, sáb o dom) sin embargo con el Excel 2016 solo me devuelve 2 caracteres. Read More | |

I have multiple minif and maxif funtions, I use the name of table headers for my min/max range, id like to simply use a cell to reference the name of the header rather than manually having to change the name.
for instance I have:
=MINIFS(table23[Grades],c ... Read More=MINIFS(INDIRECT("Table23["&D1&"]"),.... HOwever, I find it a bad idea to actually use INDIRECT because: 1. The fu... Read More | |

Hi | |

I'm trying to create a formula on excel on B2 through B1000 that takes the average of each individual row starting on row 2 so for the first row in B2 it would be =AVERAGE(C2:Z2) . Then B3 would be =AVERAGE(C3:Z3) and so on, what i would like to do is sel ... Read MoreHi Jade,
I can imagine that the data in your spreadsheet looks like this:
So, you can put this formula into cell B2: =AVERAGE(C2:Z2) And then copy it down using the Fill Handle. ... Read More | |

Hello! I am attempting to make a monthly template which can be used for the next several years to track some data. My goal is to make this template in a fashion to self-update if a few key components are keyed in.
=IF(('Date Calculations'!$G$11)=3,"=DATE ... Read MoreHi Benjamin,
Sorry, but I didn't catch how it works, with sample file could be easier. Your formula like =IF(A1=3,"=Date(2019,A1,31)") returns text "=Date(2019,A1,31)" ... Read More | |

In the above example I want to lookup B5 and insert into col 4 (G) the value in A5 - that was easy enough but then I need it to populate cols up to the col in C5 with the same value (A5) so it looks like this:
The values in B5 and C5 will change in subseq ... Read More | |

If I input a test result say 375. In the box below is it possible to set a limit 300-700 green, 200-300 yellow, 0-200 red, 700-800 yellow and 800-infinity red? Depending on my test results that I input would the colors change automatically to the limits.
Yes you can set the value based on your color scale.. you can use the condition formatting and place the below formula. 1. Select the cell you want the forma ... Read More | |

I am wanting to pull a report together that takes data in specified cells from four other tabs based on the content of an entry in a particular cell within the Report tab.
I'm not sure which is the best way to go about this or the formulae/macro to use. ... Read More Hey Katrina-
It would help if you used some sort of ID in the sheets with people that way if you have multiple cities on the list you can be sure to pull the correct en ... Read More | |

I have 112 sheets and 112 names, I would like to rename all of the sheets. How can I do this? Hi Hursh,
You can do this by using a VBA code! But you need to have these name listed in a worksheet stating from cell A1 as follows:
Then you can depend on this code to r ... Read MoreBest Response confirmed by Hursh Patel (Occasional Contributor)
| |

I've used match (and index) function for getting numbers from access database pulled in another excel sheet. I've noticed that it doesn't work properly, here is a case: =IFERROR(INDEX(AccessINVENTORY!$K$2:$N$5243;MATCH(J$6&$E$1& Hi Jelena,
Without seeing the file it's hard to say why 1177 doesn't match and 1178 matches. Perhaps you could reproduce in a small sample to share here. Read More | |

I am working on a timekeeping worksheet that keeps track of anticipated vacation time. For each 7 hours of overtime worked, the time is kept in a "bank" to be used for vacation days. 7 hours of overtime equals one day of vacation. The formula looks at ... Read MoreHi Renee,
Please try this formula in column H. =IF(OR(D1>=7,D1>=14,D1>=21),"X","")
I hope I understand you well! Regards Read More | |

Hi there, please can someone help? I'm using an absolute cell reference, but the formatting doesn't carry over... copy/paste? yes, but =acr as the result of an arithmetic function, no. (Excel 2013) Read More | |

Hello Everyone,
I have a starting date (Sheet1!F8), and 2 dates to compare to (A6, and A7), If A6 or A7 is later than Sheet!F8, I want a name to display in the field (imported from Sheet1!F6). However, If A6 is later than the starting date, but A7 is stil ... Read MoreHi Martin,
It could be =IF(AND(A6>Sheet1!F8,OR(A7>Sheet1!F8,ISBLANK(A7))),Sheet1!F6,"") | |

Hi I would like to make a venn diagram using three circles to show the overlap between three lists of names. I dont want to use the art version of it, I want it to populate from data. I have attached a spreadsheet to show the lists. If a venn diagram is t ... Read MoreHi Ian,
I've seen somewhere how to do Venn diagramm without built-in art tool, looks like a lot of manual work. In any case I may advise nothing here.
If to generate over ... Read More | |

Hello, I am creating an invoice report sheet and am looking at using IFS AND formula(s) to update a status column based on dates provided in multiple cells. looking for help with creating a single formula based on the below (if possible)... Criteria: - If $G6
Hello,
=IF(COUNT(G7:I7)=0,"Invoice not generated", Best Response confirmed by Philip Cassidy (New Contributor)
| |

I'd like to use a simple COUNTIF function on a range of cells - the cells show either an 'M' (male) or 'F' (female).
However the values for those cells actually come from another tab in the worksheet so the cells I'm counting contain a formula to pick up ... Read MoreHi Angela,
Is that something like =COUNTIF(AnotherSheet!A1:A10,"M") or I didn't catch? | |

Im working on a finance spreadsheet. I want a formula that would allow me to 'transfer' money from one budget item to another budget item.
For instance Cells Q12-42 (budget items) would look at Cells Y12 through Y999999 (Transfer from listed budget) and Z ... Read MoreHey John-
Hope you're doing well! Maybe try using a SUMIF() formula like the below example to solve your issue (See attached workbook for further reference):
Read More Best Response confirmed by john franklin (New Contributor)
| |

Is there a way to copy formulas accumulating totals without retyping each formula. For example we need to total vendor by vendor month by month spending and accumulate those totals in a spreadsheet that totals the annual amounts by vendor. The formula w ... Read More
Attached is the spreadsheet. The last time I hit reply it did not give me an option to Browse. I hope when I hit reply this time it gives me that option.
Sorry, when I hit replay it sends the message before I can attach the spreadsheet. It doesn't have a brose option just "cancel" or "reply".
Hi Michael
Do you have a sample file you can upload for us to see? Cheers Damien | |

Hello,
I am trying to use the RATE function to calculate the rate of return on my savings but I keep getting an error. I am saving $100 every month and have been doing so for 14 months. I have currently $1,450 in my account. I am entering the parameters a ... Read MoreHi, The #NUM! error message you are seeing is because the PMT argument is not negative.It is important to remember that the signs (plus or minus) are very significant: A ...
Read More
n | |

I have created a basic "movie draft" spreadsheet, where people pick movies and their box office totals are totaled up and the person with the highest overall total wins.
When I try to sort the leader board by rank (see attached spreadsheet) the SUMIF Form ... Read More | |

I have a workbook that has about 10 worksheets. Each worksheet is a Departmental list of upcoming tasks. I need to create another worksheet that will look at each of the other worksheets and show me a list of all of the tasks that are within 30 days of ... Read More | |

Hello everyone,
I am trying to help a friend create her Excel sheet. We are both sort of new to Excel but eager to learn. I have something like that but: -I use google drive (modules) to insert new items to the list (you have to create a module asking for Day (if it's different from the date ... Read More | |

Hi all
Is this possible?. I would like to add several cells together then add "5" to the total if one cell contains the text 'yes'.
I have so far
=SUM(B1,C1,D1,E1)
please help thanks Read MoreHi, to all!
You can use this formula (non CSE formula):
Blessings! Read MoreHi, Hi,
Yes, this is possible!
Try this formula:
=IF(SUM(IFERROR(SEARCH("yes",B1:B10),0))>0,SUM(B1:B10)+5,SUM(B1:B10))
Best Response confirmed by Titchard Family (New Contributor)
| |

Hi, am working on five columns. The first column is date, the second column is time in, the third column is time out. If I want the fourth column to to give a calculated value (time out minus time in) Something like the attached? Also can you clarify the part about the list of dates.
Do you need the weekday result not to show if the the date falls in the list? Read More |

Top Liked Comments

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © 2017 Microsoft