# Search results

2. ### SUMIF Based on Date and Text

Hello Paul, Please share your sample workbook. You can use dummy data. Otherwise, it won't be possible to understand the value of your mentioned ranges.
3. ### Hello Elk, I hope you are doing well. You can check your spreadsheets for the solution. The...

Hello Elk, I hope you are doing well. You can check your spreadsheets for the solution. The formula we used to achieve your expected result is: =INDEX(\$A\$2:\$F\$4,MATCH(A11&B11&C11&\$H\$9,A2:A4&B2:B4&C2:C4&D2:D4,0),5)
4. ### [Solved] Rank Formula

You can use this formula : =IFERROR( IF(D5=0, "",IF(D5>0, IF(...
5. ### [Solved] Rank Formula

Dear Jululian, I hope you are doing well. I've used the ROUNDUP and ROUND formulas to avoid the decimals in rank. Where numbers are rounded up if the decimal values are less than 0.5, or rounded and added +1 to the next integer if they are equal to or greater than 0.5. You can change the...
6. ### [Solved] Autofill formulas, exclude the auto fill for certain cells

Hello Hajjash, I hope you are doing well. You can use the absolute reference if you don't want the autofill or auto increase of rows and columns. Here is the updated formula. =SUMIFS('Calendar Tracker'!\$O\$2:\$O\$1517, 'Calendar Tracker'!\$B\$2:\$B\$1517, "="&\$B36,'Calendar Tracker'!\$H\$2:\$H\$1517,"<>")
7. ### [Solved] Need Excel Formula to get sum of all numbers in any cell with Specific text next to the number

Hello Sweetbrwnshugar, I hope you are doing well. I've used a combination of different functions. I applied it to all the attendance codes in your Excel file. Note. Don't use the same code multiple times, try to use unique codes. Use VAC-P instead of P-VAC. Here is the formula...
8. ### Excel 2021 on Mac how to get form back

Hello Spidey, You can manually follow the articles to create a data entry form manually or by using VBA. How to Create Data Entry Form in Excel How to Create Data Entry Form in Excel VBA

10. ### [Solved] Regarding Lookup formula

You can swap your Emp Id column. Keep your lookup array (Emp Id) on the left side. I've inserted an image and attached the Excel file for your better understanding. Or you can use the VLOOKUP function with the IFERROR function. It will give the same result as the XLOOKUP function. Kindly...
11. ### [Solved] Regarding Lookup formula

Hello Ashish, Hope you are doing well. Please tell me one thing, in which Excel version are you using the XLOOKUP function?
12. ### [Solved] I desperately need help on how to create excels for each of these problem. Could someone please help me!!! Please I need help!

Kindly open a new thread with a new problem to get a reply and solution quickly.
13. ### [Solved] combine formula (IF AND & data validation)

You are welcome.
14. ### [Answered] MULTIPLE IF CONDITIONS FOR MULTIPLE PARTIAL TEXT MATCH

Can you please tell us which version of Excel you are using? If you use Excel 2010 and later versions you can use the VLOOKUP function mentioned above. Here I am attaching a drop-down list with the previous formula so that if you enter any value in E4 cell then you will get the respective HSN...
15. ### [Answered] Using VBA to pull data from a website fails on a lib "user32" statement

Hello Jburgauer, Your problem seems a bit difficult and time-consuming and to solve each and every requirement a specialized team is needed. If it's part of any project or you want further help you may contact us at [email protected]
16. ### [Solved] Paye As You Earn Calculation

Dear Maps, You are most welcome.
17. ### [Solved] compare rows to find duplicate and copy non duplicate to other worksheet

Dear bigMe, You are most welcome.
18. ### [Solved] Format cell spacing

Hi tac45, You are most welcome.
19. ### [Solved] open files in folder and check if there is a blank in column A then delete entire row before copy the data

Dear bigMe, You are most welcome.
20. ### [Solved] I have a question regarding mail merge. I have to email multiple records associated with a single email address, how to do it?

Dear Hassan, You are most welcome. Keep sharing your Excel-related problems with us.

Members online
1
Guests online
17
Total visitors
18