There is any built-in function that convert a currency or number in portuguese words? How can I transform this in a easy way? Thanks

Hi, If I have COUNT(A1:A100) with a total in the row #101 and when a user insert a row between the 98 and 99 rows the function will be COUNT(A1:A101) and...

I have as extensive data set and some data is missing in places, I want to use linest and reference my X and Y variables to multiple non-connecting cells. ...

I want to assign a new macro to an old button. The button does not have sizing handles, thus no menu appears - cannot assign a macro. Also, cannot resize the...

The following are columns in worksheetA: TrkCase Order iou9876y7 p0987ewuu The following are column in worksheetB: CaseNo Order

I need help with the a vlookup formula that needs to use wildcards. Sheet 1 has the following columns: MSO# ORDER NQCT8 111 NQCT8 222 NQFH4 ...

About a year ago I got a formula from this site and was told that when I hit enter I needed to do something else to make it work. It worked great at the time...

I have the following example of cell values in the MSO column on Sheet1 MSO 088234592 088234592 088234592 088234592 NPQW1 NQCT8 NQCT8

The only option I could choose from format is to show negative numbers with "-" in front but I want to show negative number in brackets.

I have one cell with the following formula in Column Input!H2:H1000: {=INDEX(AF8:AI8,MATCH(TRUE,AF8:AI8=0,0))} it produces the following number: 8175702492...

What type of formula would respond to the following conditions 12 (excel seems to only permit up to 7...is it possible to get around that?): IF Any Cell...

If I have a column with some repeated numbers: 58 168 168 25 .... How could I count the cells from the column to get 3 (not 4) as a result - to be able to...

How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.

I would like it to SUM IF (Input! Column H = to cell AZ19 AND Input! Column A = to cell E2 , then sum Input! Column E) The two conditions: Input! Column H =...

How would one include the following conditions in a folmula IF Column A= A1 and Column B =B1 then C1=1 IF Column A= A2 and Column B =B1 then C1=2 IF Column...

How would one include the following conditions in a folmula IF INPUT worksheet Column A= A1 and INPUT worksheet Column B =B1 then C1=1 IF INPUT worksheet...

I have a main spreadsheet with columns as follow: A C AT Product ID Group TOTAL BBB TOP ...

I don't want to see the grid lines when I open up an excel worksheet. How do I make the lines disappear, as in the templates? Thanks.

What type of folmula would respond to the following conditions: IF Any Cell in Column AA= A1 and Any Cell in Column AB =B1 then C1=555 IF Any Cell in Column...

Hello experts, Is there a way to set Excel to open any/all workbooks/sheets at N%. Everytime I'm given an xls doc, I end up shrinking it down to 75 or 80% to...