## Manager Finance

I need to find out a formula by which i can replace/substitute comma to dot and dot to comma in same cell. By:

Excel 2003 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

I need to find out a formula by which i can replace/substitute comma to dot and dot to comma in same cell. By:

I need to find out a formula by which i can replace/substitute comma to dot and dot to comma in same cell. By:

I need a macro to copy 2nd row of data to alternate columns. When i tried with macros by recording the operation, it does not work. Also, with VBA code, it …

I have an excel file that has 243 rows with excel file names in one column. I want to pull data based on that excel document but don’t want to have …

If i have a column with Yes, YES, Noo, No and N values but want to make all these either a NO or a YES, how do I go about it? By:

If i have a column with Yes, YES, Noo, No and N values but want to make all these either a NO or a YES, how do I go about it? By:

I am trying to write a code in VBA to change the tab color based on cell value. The code I have now works when I manually input the key word. However, the cell …

I am trying to subtract time values but only if the original cell is not 0. L15 is a static value of 6:30 (6 hours and 30 min). I am subtracting cell G12 but …

I am trying to find different trends within service desk tickets data that i have. I want meaninful data i can use from it. I want to create different reports …

I want to build Target vs Actual Dynamic Chart with a list button added to it …. I have three teams, team 1 is with some rows (say first 8); team 2 with …

I want to find out the hourly rates of employees by looking up at their skills and experiences.I have a separate dataset in which all the data of the employees …

TOTAL MZN ZAR USD 200 200 200 No Date Currency Narrations Debit Credit Balance MZN Balance USD Balance ZAR 1 1-May-19 MZN Income 100 100 2 …

«Папиловит» — быстро и безопасно избавит от любых папиллом и бородавок. Наш сайт: …

«Папиловит» — быстро и безопасно избавит от любых папиллом и бородавок. Наш сайт: …

Hi, I have a registration excel list that has names, addresses, and cells that i mark with an “x” if they have prepaid for a tshirt and another …

Dear, i want solution for the below case, i want to add Male/Female Automatically Based On Mr./Mrs/Ms By using IF formula. like If 1st word of the cell = Mr. …

sir how to Auto split this 450 units in to 307010010010050 please any Formula for this… ( in to Rows)… By: Tom

Need help with the formula of cells highligted in red & if the excel could get even simpler By:

Hey! I am looking to find a way to show a finalized quantity of inventroy by entering the date in value, date out value, and overall quantity. Something along …

I have the table below and would like to extract the room nights and the room revenue per month to another sheet. What formula do I put in the other sheet to …

Hi, I am new to using vba and have taken on a task on changing the date format in excel using vba. The current format is : M 8:30 AM-5:30 PM; T 8:30 …

I have looked all over and not quite found the answer to my question. I have tried a lot of INDEX and MATCH posts which offer COUNTIF or an absolute, like 3 …

«Папиловит» — быстро и безопасно избавит от любых папиллом и бородавок. Наш сайт: …

I need help with spreadsheet that I have colums with dates by formula and want to use conditional formatting to change color of cell if a manual data …

Good Day, I was wondering what formula I can use for the following scenario? Column A: I have various client numbers, but some are repeated. Column B has …

Dear Concerned, I am having problem on using excel. I will explain my problem and pls tell me how to get things done. I’m working in a small …

the following code snippet is used as follows Cell #f21 has a value of tograms(a21,b21,16) A21 is typed as a numeric and has a value of 16 B21 is typed …

hello, I am trying to figure out an excel formula for the problem below. If Apple with the condition number of 23, and 23 fall between min/max range from …

«Папиловит» — быстро и безопасно избавит от любых папиллом и бородавок. Наш сайт: …

Need some help, I need to count the number of cells (in a column) that has a certain word in it based on the date in another cell (the date is formatted …

i need to create if inside if funtion if cell a contain text then continue to the next contion . if b contain text then c equal to if not …

Hello! Here is my problem: Cell- A1 has a date of 3/15/1950 Cell-A2 has number of 65 Cell-A3 has a date of 1/1 (no year) Cell-A4 formula What would the formula …

What are the advantages of creating aggregates using sumifs() rather than using a pivot Table? Kindly help in choosing three that applies from below: 1. …

Hi – thank you for any thoughts on this – grateful for your time. Here’s a formula that calcs a weighted average within a data table. …

Hi, So my boss gave me a project. We are a shoe company with many many skus, she wanted me to create an excel spreadsheet that could automatically populate our …

This one is for salesforce admin. In column A we have mixed IDs some are 15 long and some 18 long, case sensative! we like to convert all to 18. in …

hi, i have a data of entire month which shows each date wise output quantity. Each date have more than 100 rows. i need sum of output quantity of each date …

have two sheets > SALES! & stocks! date & code in SALES!$C$6:$C$5088 & SALES!$E$6:$E$5088 respectively date out & item code in …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.