los

  1. T

    If & COUNTIF Statements for Productivity

    For my work my productivity is tracked and recorded, however the database software our company uses is garbage and I have an excel spreadsheet that I prefer to use. So what I track is: Encounter # If it is a NB (NewBorn), Y for yes, nothing if not The LOS (Length Of Stay), # Depending on...
  2. C

    Numeración por color

    Buenos días En el rango B3:B43 tengo una lista de nombres, algunos de ellos están en rojo (font, color). Solicito ayuda para crear en la columna A la numeración necesaria (1,2, 3, etc.) para los los nombres en B que están en rojo. Gracias por su ayuda, ColdGeorge
  3. L

    vlookup to see if 2 teams have played each other in different columns

    How can I make a formula to find what team has played Los Angeles Rams in week 1 and 2 and other weeks. I know you can use the vlookup formula in week 1 and use the vlookup choose in week 2 to see what team Los Angeles Rams played. I want to be able to make a formula that when I place it in...
  4. A

    Índices de Geary y Moran

    Cómo puedo calcular los índices de Geary y Morán.
  5. P

    Generating a list ranked by value

    Hi everyone I have a table in A1:D9 in which a unit is plotted for each person against various locations. Cell G1 is a data validation/drop down in which you can select a person from the table (in the example below I have taken Person 2). The formula therefore needs to reference cell G1. I...
  6. V

    Necesito ayuda para actualizar un código

    De antemano gracias por acudir a mi llamada de ayuda. Tengo el siguiente código en la hoja8 de un libro de Excel en la que tengo una base de datos de artículos. En la columna J de esta hoja tengo el dato “Precio de compra del artículo”. Lo que realiza la macro que adjunto es, si se modifica el...
  7. P

    if same value in a range, return yes

    Hi, I have a big table where I need a formula to do the following: if six cells in a column contain the same value, the formula should return "yes" Example: <colgroup><col></colgroup><tbody> column N Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles...
  8. P

    if all values in a range are the same, return yes

    Hello, I have a table in Excel where I want to have a formula which if all values every six cells in a column are equal, returns yes for the six cells and to return no if the values are not equal. Here is an example. The formula should return yes, all the cells in column N are the same...
  9. P

    if all values in a range are the same, return yes

    Hello, I have a table in Excel where I want to have a formula which if all values every six cells in a column are equal, returns yes for the six cells and to return no if the values are not equal. Here is an example. The formula should return yes, all the cells in column N are the same...
  10. L

    Función o Macro para buscar en función de un dato y que me traiga un valor de una columna con vacios

    Tengo una base de datos en la que ingresan valores dos perfiles de usuarios, los unos ingresan determinada información y se registra la fecha en que lo hacen. Estos datos son asignados por el primer perfil de usuario y asignados al segundo perfil, el cual (2do perfil) registra la fecha en...
  11. H

    Categorization of Data

    Dear Team ! I have an excel sheet containing 25K records. Titles includes First Name, Last Name, Title, Location, Company & Email. I wanna use my sheet as a database. For example I need all Junior Accountants in titles from Los Angeles, the should be displayed accordingly. How to apply...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top