User Profile
ajee10x
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Find the sum of a specific value within multiple values
Muhammed_Neamy Another solution! You can use the Solver add-in in Excel to find the combination of values in the column that add up to 17. Here are the steps to follow: Select the cells containing the values in the column that you want to search. Click on the "Data" tab in the Excel ribbon. Click on the "Solver" button in the "Analysis" group. In the Solver Parameters dialog box, set the following options: Set the "Set Objective" field to the cell where you want to display the sum of the selected values. Set the "To" field to "Value of" and enter 17. Set the "By Changing Variable Cells" field to the range of cells containing the values in the column that you want to search. 5. Click on the "Options" button and make sure that the "Assume Linear Model" option is unchecked. 6. Click on the "Solve" button and wait for Solver to find a combination of values that add up to 17. 7. If Solver finds a solution, click on the "OK" button to apply the solution to your worksheet. Note that Solver may not always find a solution, especially if there are no combinations of values that add up to 17. In that case, you may need to adjust the values in the column or try a different approach. Also, Solver is an add-in that may need to be installed and enabled in Excel before you can use it.30KViews0likes0CommentsRe: How can I add my photo to my personal profile in the Microsoft Community Hub?
danielklenda85 To add your photo to your personal profile in the Microsoft tech community, follow these steps: Log in to the Microsoft tech community website. Click on your profile icon in the upper right corner of the screen. Select "My Profile" from the dropdown menu. Click on "Edit Profile" on the right side of the screen. Click on the camera icon in the circle next to your name. Select the image you want to use as your profile picture from your device. Adjust the image as needed using the cropping tool. Click "Save" to update your profile picture. To get your photo approved for your Microsoft tech community profile, make sure that the image you choose meets the community guidelines. The guidelines state that profile pictures must be appropriate and not contain any offensive, explicit, or copyrighted content. Once you have updated your profile picture, it will be reviewed by moderators to ensure it meets the community guidelines. It may take some time for your photo to be approved, so be patient. If your photo is not approved, you will receive a notification explaining why and what you can do to fix it.3.2KViews0likes3CommentsRe: Second to last value from table with condition
matt0020190 You can use the following formula to get the second to last value for a specific week number: =INDEX(B:B,MAX(IF(A:A=week_number,ROW(B:B)-ROW(B1)+1))) Replace week_number with the week number you're interested in. This is an array formula that uses the INDEX and MAX functions. Here's how it works: IF(A:A=week_number,ROW(B:B)-ROW(B1)+1) creates an array of row numbers where the week number matches week_number. The ROW(B:B)-ROW(B1)+1 part is used to adjust the row numbers to start at 1, since the formula will return an array starting from the first row. MAX(IF(A:A=week_number,ROW(B:B)-ROW(B1)+1)) finds the maximum row number in the array, which will be the row number of the last non-blank cell in the specified week. INDEX(B:B,MAX(IF(A:A=week_number,ROW(B:B)-ROW(B1)+1))) returns the value in column B at the row number found in step 2. Make sure to enter this formula as an array formula by pressing Ctrl+Shift+Enter instead of just Enter. This will add curly braces around the formula in the formula bar to indicate that it's an array formula.7.7KViews0likes0CommentsRe: How to add additional folders
You can add additional folders to be backed up by OneDrive by following these steps: 1. Open the OneDrive app on your computer. 2. Click on the OneDrive icon in the system tray and select "Settings." 3. In the "Account" tab, click on "Choose folders." 4. Select the folders you want to add to OneDrive for backup. 5. Click "OK" to save your changes. Once you've added the folders, OneDrive will automatically back them up to the cloud. Any changes you make to the files in these folders will be synced to OneDrive and to any other devices where you have OneDrive set up. It's important to note that adding additional folders to OneDrive may increase the amount of storage space you use in OneDrive, which may require you to upgrade your storage plan.76KViews0likes2CommentsRe: Find the sum of a specific value within multiple values
Yes, there is a formula you can use to find the possibilities that add up to a specific value. The formula is called "SUMIF" and it allows you to sum up values in a range based on a specific criteria. Here's how you can use it in your case: 1. In a new column, enter the formula "=SUMIF(range,value)" where "range" is the range of values you want to check and "value" is the specific value you want to find the sum for. For example, if the column of values is in column A and the client transferred an amount of 17, the formula would be "=SUMIF(A:A,17)". 2. The result of the formula will be the sum of all the values in the range that match the specific value you entered. In your example, if there are values of 8 and 9 in the column, the formula would return a result of 17. 3. You can then use a filter or conditional formatting to highlight the rows that contribute to the sum. In Excel, you can use the "Filter" function to filter the values in the column based on the criteria you entered in the formula. This should help you identify which invoices add up to the lump sum transferred by the client.31KViews0likes2CommentsRe: How to change a single cell in excel
Hi! Not a dumb question at all, happy to help. To change a single cell in Excel, you simply need to click on the cell you want to change and start typing your new value. Alternatively, you can double-click on the cell to enter edit mode. To add conditional formatting to a cell, follow these steps: 1. Select the cell you want to format 2. Go to the "Home" tab in the ribbon at the top of the Excel window 3. Click on the "Conditional Formatting" button 4. Choose "Color Scales" and select the color scale you want to use for your formatting 5. Set the minimum and maximum values for the scale based on the number of days required to complete the task 6. Click "OK" to apply the formatting to the cell That's it! You should now see a color bar across the cell that reflects the number of days required to complete the task.4KViews0likes0Comments
Recent Blog Articles
No content to show